/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

15 votes111 views2 answers
How to drop database name in postgresql
SQL
0 vote160 views1 answer
How to compile a function in oracle
SQL
7 votes121 views2 answers
N highest salary in sql
SQL
9 votes110 views3 answers
Show table columns mysql command line
SQL
2 votes117 views2 answers
Postgresql date at timezone
SQL
0 vote114 views1 answer
Postgresql create table with boolean column
SQL
0 vote77 views1 answer
Kannst du deine finger trainieren
SQL
11 votes115 views2 answers
Mysql disable safe mode
SQL
0 vote77 views0 answer
SQL
3 votes128 views1 answer
Where id is in list sql
SQL