/SQL/Find nth highest salary of an employee

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

Similar codes

1 vote312 views1 answer
How to check the mysql version mac
SQL
0 vote336 views2 answers
Mysql calcular idade
SQL
1 vote324 views2 answers
Pad zero sql server
SQL
1 vote310 views2 answers
Mysql join two tables
SQL
0 vote340 views1 answer
Openquery update linked server
SQL
2 votes325 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote257 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote310 views1 answer
Sql anywhere create procedure
SQL
1 vote286 views2 answers
Mysql SELECT
SQL
0 vote363 views1 answer
Array aggre distinct postgres
SQL