/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 vote381 views2 answers
Mysql extract number from string
SQL
3 votes316 views1 answer
If 0 return null else return query mysql
SQL
1 vote356 views1 answer
Oracle select first result
SQL
0 vote365 views1 answer
List all permissions on a table in postgres
SQL
1 vote345 views1 answer
Select if then postgresql
SQL
8 votes362 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote344 views1 answer
Sql trying to delete database in use
SQL
1 vote321 views2 answers
Procedure pl/sql
SQL
6 votes327 views1 answer
Rank function in oracle with example
SQL
3 votes340 views4 answers
Mysql delete duplicate rows
SQL