/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

3 votes110 views2 answers
How to load files in mysql
SQL
2 votes99 views1 answer
Oracle sql query to make column data uppercase
SQL
3 votes112 views3 answers
Postgresql random number
SQL
11 votes110 views3 answers
Change column name sql server management studio
SQL
14 votes116 views2 answers
Oracle export trigger ddl
SQL
0 vote110 views2 answers
T SQl Checking Your Username
SQL
0 vote117 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote112 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
1 vote100 views1 answer
Floor function in sql oracle
SQL
0 vote123 views1 answer
Least spark sql
SQL