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

3 votes259 views1 answer
Ms sql skip take
SQL
2 votes262 views3 answers
Postgresql reset auto increment
SQL
0 vote274 views4 answers
Mysql count table rows
SQL
19 votes271 views6 answers
Sql server drop table if exists
SQL
5 votes278 views2 answers
Create function postgresql
SQL
1 vote266 views2 answers
List tables sqlalchemy
SQL
2 votes263 views2 answers
Get all tables using like
SQL
0 vote298 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote272 views1 answer
Sql server convert to guid
SQL
1 vote268 views2 answers
Find nth highest salary of an employee
SQL