/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

14 votes288 views1 answer
Oracle new column
SQL
16 votes273 views2 answers
Oracle ddl
SQL
14 votes275 views1 answer
Excel is not a database
SQL
22 votes293 views3 answers
Remove all records from table mysql
SQL
1 vote273 views1 answer
Local sql server
SQL
0 vote282 views1 answer
Copy value from one column to another postgres
SQL
0 vote273 views1 answer
How to get initials in sql
SQL
0 vote290 views2 answers
Oracle ora-00054 how to unlock
SQL
2 votes280 views1 answer
Mysql Incorrect column specifier for column
SQL
2 votes260 views1 answer
Insert from table tsql
SQL