/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

2 votes193 views1 answer
How to add where command in update comand with joins
SQL
0 vote205 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote202 views1 answer
Get last three characters in mysql column
SQL
2 votes205 views3 answers
Postgresql reset auto increment
SQL
5 votes209 views1 answer
Sql check if date is between 2 dates
SQL
1 vote231 views1 answer
Sql order by timestamp
SQL
0 vote196 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
1 vote226 views3 answers
Postgresql get difference between two dates
SQL
0 vote206 views1 answer
Java sql timestamp now
SQL
0 vote207 views1 answer
Delete record by id sql
SQL