/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 vote209 views1 answer
Su: Authentication failure mysql
SQL
0 vote254 views1 answer
Sp help text in postgresql
SQL
0 vote254 views1 answer
How to use sqlcommand
SQL
7 votes228 views1 answer
Sql pagination oracle
SQL
0 vote210 views1 answer
Mysql 8 geo to json
SQL
0 vote191 views1 answer
Mysql regex exact match
SQL
0 vote240 views1 answer
FIND most frequent word in sql server
SQL
0 vote212 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
-1 vote214 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote208 views2 answers
Script all indexes in a database
SQL