/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 vote234 views1 answer
Get date from timestamp in mysql
SQL
0 vote221 views1 answer
Casterar postgres
SQL
25 votes245 views6 answers
Import mysql database command line
SQL
4 votes229 views2 answers
Convert utc to est sql
SQL
0 vote257 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote235 views1 answer
Populate db from command line postgres
SQL
0 vote225 views1 answer
Commit transaction sql
SQL
0 vote207 views1 answer
Mysql percentage of total
SQL
0 vote233 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote362 views1 answer
Sql change a colum to unique
SQL