/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 vote208 views1 answer
Mysql_num_fields in mysqli
SQL
1 vote227 views1 answer
Declare table variable
SQL
1 vote211 views1 answer
Median mysql
SQL
4 votes213 views3 answers
Mysql update with join
SQL
0 vote229 views1 answer
How do you insert boolean to postgresql
SQL
0 vote217 views1 answer
Sql server select value large text
SQL
8 votes217 views1 answer
Oracle add months to sysdate
SQL
0 vote220 views1 answer
Mysql select smaller of two values
SQL
0 vote222 views1 answer
How to login to mysql in homestead
SQL
1 vote212 views1 answer
Mysql pretty date format
SQL