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 vote274 views3 answers
Sql count condition
SQL
0 vote358 views1 answer
Run docker container with database as rds metabase
SQL
0 vote286 views1 answer
Sql order by except one row
SQL
17 votes266 views3 answers
How to change a collumn name in sql
SQL
0 vote255 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote287 views1 answer
Alter column to not null with default value sql server
SQL
1 vote278 views1 answer
Ubuntu access database from terminal
SQL
0 vote292 views1 answer
Copy row from db to db mysql
SQL
5 votes271 views1 answer
Alter table add comment oracle
SQL
0 vote283 views1 answer
Sql get number of days between two dates
SQL