19- LIMIT and OFFSET in SQL | Find Nth highest salary using LIMIT Clause | Interview Question
ฝัง
- เผยแพร่เมื่อ 6 พ.ค. 2023
- Are you new to SQL and looking to learn the basics quickly? Look no further! This tutorial is designed for beginners and will teach you the fundamentals of SQL .
So what are you waiting for? Grab your coffee and let's get started!
Complete SQL Tutorial Playlist- • SQL / MySQL Tutorial
Key Moments-
LIMIT & OFFSET - 01:00
LIMIT with ORDER BY - 05:30
Find 3rd Highest Salary - 06:13
📚 SQL Practice Questions -
codeera.netlify.app/sql-pract...
🔶Create Employee Table
codeera.netlify.app/wp-conten...
🔶Insert Data into Employee Table
codeera.netlify.app/wp-conten...
Connect with us on different platforms
✅ Visit Our Website: codeera.netlify.app/
✅ Subscribe us on TH-cam: / @codeera2020
✅ Follow us on Instagram: / codeera_
✅ Follow us on Telegram: t.me/joingroupCodeEra
📌18- ORDER BY Clause in SQL
• 18- ORDER BY Clause in...
📌17-IS NULL & IS NOT NULL Operators | IFNULL() Function
• 17- IS NULL & IS NOT N...
📌16-LIKE & NOT LIKE Operator | Wildcard Characters | ESCAPE Character
• 16-LIKE Operator & Wil...
📌15-BETWEEN & NOT BETWEEN Operator | IN & NOT IN Operator in SQL
• 15 - SQL BETWEEN & NOT...
📌14 - AND, OR, NOT Operators in SQL | Logical Operators
• 14 - AND, OR, NOT Oper...
📌13 - WHERE Clause in SQL | Types of Operators | Comparison Operator
• 13 - WHERE Clause in S...
📌12-SELECT Command in SQL | DISTINCT | FROM Clause
• 12-SELECT Command in S...
⭐Part 1:Top 9 SQL queries for interview -
• Top 9 SQL queries for ...
⭐Part 2:Top 9 SQL queries for interview -
• PART 2 : Top 9 SQL que...
⭐Top SQL Interview Question
• Top SQL Interview Ques...
⭐Interview SQL Query On Joins
• Interview SQL Query On...
⭐DBMS vs RDBMS
• DBMS vs RDBMS | What i...
⭐SQL Query To Swap Value Of Male and Female In Single Statement
• SQL Query To Swap Valu...
#sql
#sqlcourse
#sqlforbeginners
#datamanagement
#database
#sqltraining
#sqltutorial
#dataanalytics
#dataanalysis
#learnsql
#sqlqueries
#sqlprogramming
#onlinelearning
#techskills
#elearning
#onlinetraining
#programming
#coding
#careerdevelopment
#beginners
#MySQL
#databasemanagement
#DBMS
#techtutorials
#sqlforbeginners
#sqltutorial
#sqlcourse
#sqltraining
#simplilearn
#sqlintroduction
#sqlfullcourse
#oracledatabase
#oracle
#oraclesql
#ask4help
#learncoding
#orderby
#clause
#limit - วิทยาศาสตร์และเทคโนโลยี
Your videos are really helpful a lot , thank u so much
Excellent teaching skills 😊
thanks a lot my best teacher for this video - best wishes
Hi Saloni, Very Good Lectures, Its really helpful. One small thing. I can create the table but couldn't insert data which you were given for sample table link in a description. Its showing error on (gender ENUM ('M','F') NOT NULL). Please check once is there any problem on that particular column. I am using MySQL Workbench for practice. Thank you in advance. Grade Job. Keep it up....
HELLO MAM,VERY NICE EXPLANATION...WHERE CAN I FIND WINDOWS FUNCTIONS IN SQL ?UR VIDEOS ARE VERY HELPFUL...
Hi, Your SQL videos are fantastic! They've been instrumental in helping me grasp the concepts easily. Thank you for your clear explanations and engaging teaching style. I'm having trouble finding the question-answer link also I'm facing an issue downloading the data. Could you please guide me on where to locate it? Thank you for your assistance.
codeera.netlify.app/sql-practice/
Here you will find all practice question and answers
Madam, when will today's lecture be published?
what is offset , you haven't expalined this as in SSMS limit syntax does not work
Videos are very helpful please make videos in trigger,index,view and stored procedure if possible
will upload soon in this SQL tutorial series.
Thank you
Hello mam in the link there is no question of current LIMIT clause and OFFSET clause..last pdf upload was on order by clause😢
Please check the website or link .It's updated now
its good to use subqueries the answer will be accurate.
Saloni plz tell me the last 3 rows
mam, in the employee table data in the salary were 6000, 4800,4000, 3000 .......so the 3rd highest salary will be 4000
but the query you performed in the end of the video, the output was coming 3000 which is not correct it should be 4000
Hello! If you check again, you'll see that the answer 3000 is correct because in the last example, the output should be the third lowest salary, only in the previous example the question was related to the third highest salary. So, 3000 is correct because the lowest (unique) salaries are: 2000, 2500 and 3000 (ASC not DESC this time - 3000 being the third lowest). Please check again and will make sense. Keep it up!
Actually, she has explained two examples at the same time without giving a gap in between, check once again, I too confused at first same like u😅