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

8 votes372 views1 answer
Mysql dump restore
SQL
0 vote298 views1 answer
Mysql default uuid
SQL
0 vote307 views1 answer
Mac os zsh: command not found: mysql
SQL
1 vote314 views1 answer
Mysql query where in select
SQL
-1 vote323 views1 answer
Phinehas Psalm 106
SQL
0 vote335 views1 answer
Query builder doctrien return sql
SQL
7 votes323 views5 answers
Sql remove spaces
SQL
1 vote301 views1 answer
How to check the mysql version mac
SQL
0 vote327 views1 answer
Oracle session statistics
SQL
-2 votes297 views1 answer
Mysql not empty
SQL