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

0 vote331 views4 answers
First max salary in sql
SQL
5 votes296 views1 answer
List foreign key oracle
SQL
13 votes299 views4 answers
Mysql get last row
SQL
0 vote307 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote301 views1 answer
Install ms sql server management studio
SQL
1 vote526 views3 answers
Sql subquery
SQL
0 vote299 views1 answer
Redirection 301 htaccess nom de domaine
SQL
2 votes307 views1 answer
Oracle find unusable indexes
SQL
0 vote346 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote311 views1 answer
Call procedure in wordpress
SQL