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

2 votes283 views1 answer
Update trigger
SQL
0 vote313 views1 answer
Mysql remove bad character from all fields
SQL
0 vote343 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
2 votes331 views2 answers
Create table mysql integer NOT null
SQL
0 vote334 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote277 views1 answer
Mysqlimport
SQL
0 vote302 views2 answers
Mysql on update current_timestamp
SQL
0 vote277 views1 answer
Ffeathers express mysql application users login
SQL
0 vote290 views1 answer
How to use group_concat in sql server
SQL
10 votes294 views5 answers
Mysql create user
SQL