/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 vote124 views1 answer
Can we rollback in sql
SQL
0 vote155 views1 answer
Sql filter rows with condition
SQL
0 vote126 views1 answer
Copy data from one postgres container to another
SQL
5 votes159 views2 answers
Functions
SQL
0 vote209 views1 answer
Sql insert exemplo
SQL
0 vote117 views1 answer
Mysql select statement after index
SQL
0 vote141 views2 answers
Mysql dump structure only
SQL
0 vote134 views1 answer
Into operator in sql
SQL
1 vote128 views1 answer
DATE_SUB postgres
SQL
0 vote127 views1 answer
Comma seperated join mssql
SQL