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

16 votes170 views2 answers
Add column to all tables after first column mysql
SQL
0 vote187 views1 answer
Every Derived yable must have its own alias
SQL
1 vote222 views1 answer
Create sqlite database in laravel
SQL
0 vote209 views1 answer
Sql alter table order by
SQL
0 vote194 views3 answers
Sql drop all tables
SQL
0 vote184 views1 answer
Sql server user permissions and roles
SQL
0 vote195 views3 answers
Postgres date difference seconds
SQL
8 votes169 views5 answers
Grant permission in postgres
SQL
9 votes214 views1 answer
Identity insert on sql server
SQL
0 vote200 views1 answer
Sql select min row
SQL