/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 votes132 views1 answer
Ssh mysql port forwarding
SQL
0 vote135 views1 answer
Java input type sql date
SQL
4 votes147 views2 answers
Oracle sql group by date year
SQL
0 vote127 views1 answer
List MySQL Table and Index Size
SQL
1 vote128 views1 answer
Oracle lock user
SQL
0 vote140 views1 answer
Postgresql regular expression special characters
SQL
0 vote211 views1 answer
Trigger
SQL
3 votes172 views4 answers
Mysql create table from select statement
SQL
0 vote159 views1 answer
For row in sql database python loop
SQL
6 votes133 views1 answer
Wordpress change user password sql
SQL