Nth highest salary

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

3rd height salary sql

SELECT MIN(EmpSalary) from ( 
	SELECT EmpSalary from Employee ORDER BY EmpSalary DESC LIMIT 3 
);

Similar codes

0 vote187 views1 answer
Create new table pl sql
SQL
1 vote204 views5 answers
Postgresql difference between two dates in days
SQL
0 vote220 views1 answer
Codigo crear tablas sql server
SQL
14 votes190 views1 answer
Excel
SQL
0 vote189 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
1 vote195 views1 answer
Sql delete all values in a column
SQL
0 vote191 views1 answer
Check if record exists mysql
SQL
0 vote202 views1 answer
Get a list of tables and the primary key
SQL
0 vote207 views1 answer
Creating a simple notify in postgresql
SQL
1 vote196 views2 answers
Mysql join two tables
SQL