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 vote125 views1 answer
Jenkins SQLCMD run
SQL
0 vote124 views3 answers
Above average salary in sql
SQL
0 vote124 views1 answer
Python sql last insertend
SQL
0 vote156 views1 answer
Day of the week sqlite
SQL
0 vote120 views1 answer
Console output pl sql
SQL
1 vote168 views1 answer
Insert pg result of select
SQL
-2 votes131 views1 answer
Create trigger syntax
SQL
1 vote146 views2 answers
Create table if not exist
SQL
0 vote116 views1 answer
Mysql change default collation
SQL
17 votes134 views2 answers
T_sql contains
SQL