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

11 votes210 views2 answers
Mysql disable safe mode
SQL
0 vote177 views1 answer
Get date from timestamp in mysql
SQL
27 votes213 views5 answers
Mysql set password for user
SQL
13 votes179 views2 answers
Sql join
SQL
8 votes204 views1 answer
Oracle tablespace datafile max size
SQL
51 votes571 views6 answers
Installing mysql on ubuntu
SQL
0 vote173 views1 answer
MySQL FIND_IN_SET()
SQL
-1 vote173 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote175 views1 answer
Get first 3 letter of department name in sql
SQL
5 votes178 views1 answer
Oracle get foreign keys on table
SQL