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 vote350 views2 answers
How to generate a unique random number in mysql
SQL
0 vote367 views1 answer
How do I insert a blob in SQL?
SQL
0 vote352 views4 answers
Mysql count table rows
SQL
2 votes306 views1 answer
Sql select in list
SQL
0 vote362 views2 answers
Homebrew nysql launch
SQL
0 vote346 views1 answer
User defined variables in sql
SQL
37 votes349 views3 answers
Postgresql insert column
SQL
-2 votes328 views2 answers
Sqlserver docker
SQL
-2 votes341 views1 answer
Modify column name in tsql
SQL
3 votes374 views1 answer
Oracle list privileges
SQL