/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 vote141 views1 answer
Postgres concat_ws
SQL
0 vote142 views1 answer
Sql server count all tables rows
SQL
0 vote141 views1 answer
Get duplicate entry sql
SQL
0 vote131 views1 answer
How to define a save method in ruby for sql databases
SQL
1 vote153 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
1 vote140 views1 answer
Sql order by where condition
SQL
1 vote127 views1 answer
Oracle lock user
SQL
0 vote160 views1 answer
Mysql conf.d exampel
SQL
0 vote134 views1 answer
Postgresql parse json array
SQL
4 votes136 views6 answers
Sql select statement
SQL