find nth highest salary of an employee

Solutions on MaxInterview for find nth highest salary of an employee by the best coders in the world

showing results for - "find nth highest salary of an employee"
Marco
26 Jan 2018
1#Method 1
2SELECT salary FROM Employee ORDER BY salary DESC LIMIT N-1, 1
3
4#Method 2
5SELECT salary FROM Employee AS e1 
6WHERE n-1=(SELECT COUNT(DISTINCT,salary) FROM Employee AS e2 
7           WHERE e2.salary>e1.salary)
Camila
23 Oct 2019
1SELECT salary FROM Employee ORDER BY salary DESC LIMIT N-1, 1
queries leading to this page
how to pull 3rd maximum record sqlsecons hiest salary in sql without limitsecond highest salary fastest3rd highest salary in sql serverselect nth highest salary in sqlquery to find nth highest salaryfind nth highest salary of an employeeget nth salary sql serverget highest salary in sqlquery to find 5th highest salary in sqlfind 3rd highest salary in sql3rd max salary in sql sql query to display 2nd highest salaried employee details and may ask for nth highestselect 5th highest salary in sqlcorrelated subquery to find nth highest salarysecond highest salary in sqlselect top 2nd highest salary for sqlsecond highest salary in sql using rankwrite a query to determine the nth 28say n 3d5 29 highest purch amt from orders table kth largest salary in sqlsecond highest salary in teradata4 highest salary in sqln highest salary in mysqlhow to get highest salary in sqlfind third max salary in sqlhow to select highest salary in sqlfind out the highest salary in sqlsecond highest salary in sql using maxselect highest salary in sqln highest salary sql3rd highest salary in sqlnth highest salary in sqlsql query for nth highest salaryfind 5th highest salary in sqlselect third max salary in sqlthird max salary in sqllist the highest salary in sqlfind the n highest salary in sqlsql query to find the person with the third highest salarywrite a query to find the 4th maximum salary in the employees tableget n highest salary sql4th maximum salary in sqlthird hightest sql logicselect second highest salary in sql without using limitnth highest salary in sql using correlated subquerysecond highest salary in sql using limitsql query to find 3rd highest salaryhow to find fifth s highest salary in sqlhow to find nth highest salaryhow to find 10th highest salary in sql write an sql query to determine the 5th highest salary without using top or limit method sql highest ntget 6th largest in sqlsql select highest salary3rd salary in sql third highest salary in sqlsql get 3rd highest salaryselect 10th highest salary sqlfinding nth highest salary in sqlhow to find highest average in sqlmysql nth highest salarynth largest number sql query3rd highest salary in sql5th highest salary sql server querynth highest salary3rd highest salary sql querylowest salary in sqlhow to find 5th highest from sqlnth highest salary in mysqlget top 3 highest salary in sql without window function 3a find 5th largest salary in a given salary table nth maximum salary in sqln m sqlnth salary in sql serverselect n highest salary in sqlsql queries for highest salarysql nth highest salaryn highest salary in sql in big query write a sql query to get the third highest salary of an employee from employee table 3frite a sql query to get the nth highest salary from the employee table calculate 3rd highest salary sqlhow to get fifth highest salary in sqlwrite a sql query to find employee with third highest salary 2c without using top or inner queryhow to find 3rd highest salary in sqlgiven an employee table 2c find the e id and e name of the employee with the third highest salaryselect 3rd highest salary in sqlfind the nth highest salary in sqlfind 3rd maximum salary in sqlhighest salary in sqlhow to find the 3rd highest salary in sqlwrite a sql query to find the 4th maximum element from a tablehow to find nth salary in sqlsecond highest salary sqlselect nth highest salaryget kth largest element sql dense rankhow to print nth highest salary in sqlwrite a query to find nth highest salaryfind 2nd rank in sqlfind the third highest salary in sqln highest salary in sqlwrite a sql query to get the nth highest salary from the employee table 4th highest salary in sql using limit4th maximum salary using subquerytop 3rd salary in mysqlsql query for third highest salaryhighest salary sql queryselect 5th highest salary in mysqlhow to find nth highest salary in sqlsql highest salaryfind nth highest salary of an employee