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

3 votes296 views1 answer
Mysql insert on dupèlicate
SQL
6 votes274 views1 answer
Check Table Exists
SQL
1 vote298 views1 answer
Mysql print variable
SQL
2 votes323 views3 answers
How to replace null values in sql
SQL
0 vote294 views2 answers
Greater than sql server
SQL
0 vote269 views1 answer
Data types mysql vs postgresql
SQL
0 vote282 views1 answer
Oracle job session
SQL
4 votes284 views4 answers
Print pl sql
SQL
0 vote298 views1 answer
How to run mysql on terminal mac
SQL
0 vote295 views1 answer
Oracle list partitions
SQL