/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 vote262 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
3 votes275 views2 answers
Mysql update row
SQL
0 vote245 views1 answer
Mysql pv progres
SQL
1 vote260 views1 answer
Mysql search like order by best match
SQL
1 vote254 views1 answer
How do you use sql in you company
SQL
0 vote285 views1 answer
Array aggre distinct postgres
SQL
3 votes267 views3 answers
Mysql declare variable
SQL
1 vote244 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
6 votes271 views3 answers
Oracle all dates between two dates
SQL
8 votes256 views2 answers
Python simple connect to mysql
SQL