/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

0 vote194 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote170 views1 answer
Mysql group rows with same value
SQL
3 votes181 views1 answer
Apex set debug level
SQL
0 vote187 views1 answer
Python sqlalchemy connection show server
SQL
0 vote173 views1 answer
Heidisql check how much space a row
SQL
1 vote200 views1 answer
Mysql connect bash
SQL
0 vote184 views2 answers
Mysql unique two columns
SQL
7 votes200 views1 answer
Buy forge mods server hosting
SQL
0 vote193 views1 answer
Get who is hired in february in sql
SQL
1 vote200 views1 answer
Default
SQL