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

1 vote291 views1 answer
Sql how to duplicate a table
SQL
0 vote273 views1 answer
Mysql docker image for macbook m1
SQL
2 votes262 views2 answers
Insert all in sql
SQL
0 vote316 views1 answer
How to make sure two tables have same exact data in sql
SQL
1 vote290 views1 answer
Blob datatype in mysql
SQL
0 vote297 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
1 vote276 views1 answer
Oracle lock user
SQL
9 votes277 views4 answers
How to remove duplicate in sql
SQL
0 vote248 views1 answer
Mysql timeout 30 seconds
SQL
2 votes299 views1 answer
Sql server current date minus 5 years
SQL