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 vote310 views1 answer
Sql server query all database objects
SQL
1 vote219 views1 answer
Apex select list ORA-20999
SQL
0 vote206 views1 answer
MySQL error code 2068
SQL
6 votes248 views2 answers
How to get last element sql
SQL
0 vote234 views1 answer
Sql values not in another table
SQL
3 votes184 views1 answer
Postgresql if null then 0
SQL
0 vote218 views1 answer
Postgresql using reserved word as column name
SQL
0 vote194 views1 answer
Mysql default timestamp value to be current timestamp
SQL
0 vote167 views1 answer
Oracle function select into
SQL
2 votes206 views1 answer
Mysql application.properties spring boot
SQL