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

-1 vote46 views3 answers
Check table exist postgresql
SQL
-1 vote44 views1 answer
How to dump .csv file into mysql
SQL
0 vote48 views1 answer
How to use sqlcommand
SQL
0 vote49 views1 answer
How to install postgresql on wsl
SQL
0 vote51 views2 answers
Identity syntax in sql
SQL
0 vote44 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote44 views1 answer
Flask sqlalchemy remove duplicates
SQL
0 vote52 views1 answer
Soql update query
SQL
0 vote48 views1 answer
Create user faunadb
SQL
1 vote46 views2 answers
Pad zero sql server
SQL