/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

34 votes398 views6 answers
Alter table add foreign key mysql
SQL
2 votes355 views1 answer
Coalesce sql
SQL
7 votes404 views2 answers
3rd height salary sql
SQL
0 vote353 views1 answer
Mysql disable triggers
SQL
3 votes344 views2 answers
Postgres download
SQL
2 votes316 views1 answer
Sql ignore accents
SQL
0 vote366 views1 answer
Datatables server side filter where clause
SQL
16 votes343 views1 answer
Sql comment'
SQL
0 vote345 views1 answer
Varchar2 length in oracle
SQL
2 votes346 views1 answer
Oracle generated column
SQL