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 vote183 views1 answer
Check connections to database postgres
SQL
10 votes199 views3 answers
Sql select between two dates
SQL
7 votes177 views3 answers
Add primary key to database sql
SQL
0 vote207 views1 answer
Sql server phone constraint
SQL
0 vote183 views2 answers
Postgresql change user role grant
SQL
0 vote357 views1 answer
Sql change a colum to unique
SQL
0 vote200 views1 answer
Java nosql sort
SQL
0 vote197 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
2 votes218 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote240 views1 answer
Selecting Multiple Columns in SQL
SQL