/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

2 votes180 views3 answers
Mysql unix timestamp to date
SQL
2 votes174 views1 answer
Mysql auto increment jumping
SQL
15 votes258 views4 answers
Export mysql db using command line
SQL
6 votes236 views1 answer
How to get the size of the database in postgresql
SQL
0 vote192 views2 answers
Sql last updated
SQL
2 votes181 views1 answer
Ssh mysql port forwarding
SQL
10 votes195 views1 answer
Oracle dba_dependencies
SQL
4 votes193 views1 answer
Restart for pg_hba.conf file
SQL
0 vote269 views1 answer
Postgressql uuid
SQL
11 votes223 views1 answer
Ddl view
SQL