Query to Find nth Highest Salary in MySQL|| Important Query for Interviews|| Code With Neha
In my previous video of MySQL series I have discussed about Limit and offset clause u can check the video from above i button
Today I will be discussing a very important query which is mostly asked in interviews
Query to find out nth highest salary in employees table
So without any further delay let's get started
Syntax of limit and offset with orderby clause is
Select column1,column2....
From table_name
Where condition
Orderby column_name
Limit offset,row-count;
that's all for today Hope you all will get some help from this video
If it's so then don't forget to subscribe my channel Code with Neha and press the Bell Icon for Regular Updates
See you in the next video till then Stay Safe Stay Happy
#sql
#mysql
#mysql_workbench
#mysql8
#mysqlserver
#mysqltutorials
#mysqltutorial
#mysqltutorialforbeginners
#limitandoffset
#limitandoffsetclause
#limitclause
#limitclauseinmysql
#limitclauseinsql