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

1 vote396 views2 answers
Coderbyte sql solutions
SQL
20 votes205 views4 answers
Reset auto increment in MySQL
SQL
13 votes221 views1 answer
Sql join 3 tables on id
SQL
16 votes200 views3 answers
Tsql rename column name
SQL
0 vote204 views1 answer
Sql select where more than one record exists
SQL
0 vote238 views1 answer
Sql alter table order by
SQL
0 vote202 views1 answer
Java sql timestamp now
SQL
1 vote206 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
2 votes197 views1 answer
Q operator in sql
SQL
0 vote202 views2 answers
Check mysql timezone
SQL