/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 vote345 views1 answer
Postgres concat_ws
SQL
0 vote350 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote342 views1 answer
Components/Fields of Internal Table
SQL
6 votes342 views1 answer
Oracle rank() over (partition)
SQL
1 vote372 views2 answers
Begin transaction in sql
SQL
0 vote355 views1 answer
Mysql cast null to string
SQL
0 vote353 views1 answer
Codeigniter 3 get best-selling products
SQL
6 votes393 views2 answers
Subtr Oracle ?
SQL
17 votes364 views6 answers
Current date in sql
SQL
3 votes384 views1 answer
Oracle list privileges
SQL