/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 vote254 views1 answer
How to insert same table data using mysql query
SQL
0 vote280 views1 answer
Exectuer myssql .sql
SQL
2 votes282 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote255 views1 answer
Sql get all columns from one table but one from another inner join
SQL
0 vote262 views1 answer
Postgresql regular expression special characters
SQL
0 vote296 views1 answer
Creating h2 database in relative directory eclopse
SQL
7 votes279 views2 answers
Show size database mysql
SQL
0 vote262 views1 answer
Oracle job class
SQL
19 votes307 views5 answers
Display table in sql
SQL
1 vote264 views2 answers
Mysql current user
SQL