/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 vote362 views2 answers
Sql searching via key word
SQL
0 vote376 views1 answer
Mssql + bit + in python orm
SQL
0 vote389 views1 answer
Cannot pip install mysqlclient
SQL
1 vote344 views1 answer
Get url of cpanel database hostname
SQL
0 vote394 views1 answer
Sql remove non numeric characters
SQL
0 vote343 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote426 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote369 views1 answer
Where field is null sql knex
SQL
2 votes335 views3 answers
Application.properties spring boot mysql
SQL
4 votes376 views2 answers
Oracle default date format
SQL