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 vote297 views1 answer
Create duplicate table in postgresql
SQL
4 votes320 views1 answer
Postgresql create table with index
SQL
0 vote312 views1 answer
Get time component of datetime sql
SQL
0 vote341 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote330 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote332 views1 answer
Install sql server windows 10
SQL
-1 vote348 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
2 votes532 views5 answers
Unique in sql server
SQL
15 votes355 views4 answers
Sql update from select
SQL
11 votes333 views1 answer
Sql insert multiple rows from select
SQL