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 votes360 views2 answers
How to rename column name in sql server using query
SQL
-1 vote359 views1 answer
How to dump .csv file into mysql
SQL
0 vote372 views3 answers
Mysql regex replace
SQL
0 vote345 views1 answer
Get number of tables in database sql
SQL
5 votes389 views2 answers
Functions
SQL
2 votes369 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote363 views1 answer
Lost connection to mysql
SQL
1 vote406 views1 answer
Sql random sampling per group
SQL
1 vote344 views1 answer
Oracle case
SQL
0 vote351 views1 answer
C# datetime to sql server datetime
SQL