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 vote325 views1 answer
Redirection 301 htaccess nom de domaine
SQL
1 vote130 views1 answer
How to remove identity from a column in sql server
SQL
22 votes136 views6 answers
Create sql table
SQL
0 vote152 views1 answer
How to define a non primary composite key in sql
SQL
1 vote125 views1 answer
Base nosql
SQL
0 vote130 views1 answer
Inserted row count tsql
SQL
3 votes163 views1 answer
Mysql cli connect with password
SQL
16 votes129 views3 answers
Delete row psql
SQL
0 vote121 views1 answer
Power bi find all ids not in other tables
SQL
15 votes156 views6 answers
Drop foreign key mysql
SQL