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 vote348 views1 answer
Sqlite3 pragma foreign keys
SQL
7 votes408 views1 answer
Oracle pagination query rownum
SQL
1 vote359 views1 answer
Pentaho + pasar de excel a sql
SQL
1 vote364 views1 answer
SQL Integer devision
SQL
0 vote352 views1 answer
Import excel to sql
SQL
2 votes364 views2 answers
Mysql user access to database
SQL
0 vote352 views1 answer
Select last N rows mysql
SQL
3 votes352 views1 answer
Oracle apex warn on unsaved changes
SQL
23 votes381 views4 answers
How to show all users in mysql
SQL
52 votes619 views6 answers
Rename column sql
SQL