/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 vote338 views2 answers
How to get max from each department in sql
SQL
0 vote295 views1 answer
Mysql workbench not showing schemas
SQL
1 vote293 views2 answers
How to check username in mysql command line
SQL
0 vote305 views2 answers
PostgreSQL having
SQL
2 votes292 views1 answer
Get first 3 letters name in sql
SQL
-1 vote316 views1 answer
Can pandas fetch data from sql
SQL
1 vote308 views1 answer
Top 10 rows in mysql
SQL
4 votes339 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote325 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote299 views2 answers
Create new table plsql
SQL