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 votes278 views1 answer
Oracle list invalid password logon denied
SQL
1 vote247 views1 answer
Dropping a constraint in ms sql
SQL
27 votes239 views6 answers
Sql update record
SQL
7 votes213 views1 answer
Sql management studio display line numbers
SQL
2 votes224 views1 answer
Get hour from date sql
SQL
0 vote229 views1 answer
Oracle show running job
SQL
0 vote241 views1 answer
Sql server get date of previous sunday
SQL
5 votes241 views1 answer
Sql select ciunt
SQL
0 vote226 views1 answer
Mysql workbench indent formatting
SQL
5 votes221 views1 answer
Mysql change primary key
SQL