Nth highest salary

Find nth highest salary of an employee

#Method 1
SELECT salary FROM Employee ORDER BY salary DESC LIMIT N-1, 1

#Method 2
SELECT salary FROM Employee AS e1 
WHERE n-1=(SELECT COUNT(DISTINCT,salary) FROM Employee AS e2 
           WHERE e2.salary>e1.salary)

Nth highest salary

SELECT salary FROM Employee ORDER BY salary DESC LIMIT N-1, 1

Source: javarevisited.blogspot.com

3rd height salary sql

SELECT MIN(EmpSalary) from ( 
	SELECT EmpSalary from Employee ORDER BY EmpSalary DESC LIMIT 3 
);

Similar codes

0 vote184 views2 answers
Fanyi
SQL
1 vote141 views1 answer
Oracle repeat_interval 5 minutes
SQL
1 vote110 views1 answer
Oracle explain plan
SQL
7 votes123 views5 answers
Show details of table postgres
SQL
4 votes127 views1 answer
Adding data to table in sql python
SQL
0 vote125 views1 answer
Select nth row in mysql
SQL
11 votes124 views2 answers
Turn off safe mode mysql
SQL
0 vote125 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
2 votes133 views1 answer
Power query concatenate
SQL
0 vote114 views1 answer
Mysql add to value
SQL