/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 vote138 views1 answer
Sql select table header
SQL
1 vote127 views1 answer
Sql get all columns from one table but one from another inner join
SQL
-1 vote153 views1 answer
Mysql extract days
SQL
0 vote120 views1 answer
Get who is hired in january in sql
SQL
0 vote131 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote121 views1 answer
Install mysql 8 linux
SQL
0 vote159 views1 answer
Sqlite trim
SQL
0 vote155 views1 answer
Mysql dump with table query
SQL
5 votes164 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote130 views1 answer
Windows services sql
SQL