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 vote186 views2 answers
How to update the multiple rows in sql
SQL
2 votes201 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote184 views1 answer
Mysql workbench indent formatting
SQL
0 vote184 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote181 views2 answers
Update all linkedserver tables with openquery on db
SQL
0 vote177 views3 answers
Average salary in sql
SQL
1 vote175 views1 answer
Sql get all columns from one table but one from another inner join
SQL
0 vote189 views1 answer
Sql developer connect to sql server
SQL
0 vote226 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote148 views1 answer
Como leer datos de mysql esp32
SQL