/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

1 vote191 views1 answer
Mysql get character set
SQL
0 vote211 views1 answer
Show the colums of table sql
SQL
0 vote225 views1 answer
Mysql streaming example
SQL
1 vote211 views1 answer
Postgresql export output table as a csv
SQL
2 votes193 views1 answer
Enum in SQL Server
SQL
6 votes580 views3 answers
Sql select last id
SQL
36 votes194 views3 answers
Finding duplicate column values in table with sql
SQL
24 votes219 views6 answers
Sql change table name
SQL
0 vote232 views1 answer
Mssql find deadlocks
SQL
0 vote194 views1 answer
Postgres in operator with comma separated values
SQL