/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 vote121 views1 answer
Space not removing from column in sql
SQL
-1 vote108 views2 answers
Import data from excel to sql server automatically
SQL
0 vote128 views1 answer
SQL joins in python
SQL
12 votes107 views1 answer
Script to add new column in table sql
SQL
1 vote98 views1 answer
Mysql select and count left join
SQL
1 vote99 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote108 views1 answer
Reona
SQL
3 votes108 views1 answer
Null sql
SQL
6 votes100 views2 answers
WHERE value IS sql
SQL
0 vote112 views2 answers
Athena drop partition
SQL