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

3 votes198 views2 answers
Update Query in SQL Server
SQL
0 vote185 views1 answer
View to table sql
SQL
1 vote172 views1 answer
Sql oracle update multiple rows
SQL
1 vote185 views1 answer
Install postgresql on raspberry pi
SQL
2 votes192 views1 answer
How to delete columns in sql
SQL
1 vote171 views1 answer
SQL server query column yes or no
SQL
1 vote218 views1 answer
Concat first name and last name in mysql
SQL
2 votes182 views2 answers
Select list is not in group by clause
SQL
0 vote179 views2 answers
Sql join on comma separated field
SQL
0 vote186 views1 answer
Import excel to sql
SQL