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 vote139 views1 answer
Timestamp(0) postgresql
SQL
0 vote220 views1 answer
Sql if clause within where clause
SQL
17 votes179 views4 answers
Mysql remove ubuntu
SQL
15 votes171 views3 answers
Create table with primary key auto increment in sql
SQL
0 vote155 views2 answers
Oracle select
SQL
1 vote149 views2 answers
Mysql join two tables
SQL
1 vote136 views1 answer
Oracle truncate partition
SQL
12 votes149 views4 answers
Mysql version query
SQL
0 vote154 views2 answers
Postgresql get long running queries
SQL
2 votes150 views1 answer
Sqlite indexes
SQL