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 vote173 views2 answers
Sql search all tables for attributes
SQL
1 vote275 views1 answer
Sql check roles
SQL
0 vote149 views1 answer
Mysqldump don't drop table
SQL
0 vote126 views1 answer
Export partttion and import in oracle
SQL
0 vote97 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
3 votes184 views2 answers
Oracle sql first day of month
SQL
21 votes179 views3 answers
Average sql
SQL
0 vote146 views1 answer
Mysql sum per week
SQL
2 votes159 views1 answer
Column names in oracle sql
SQL
0 vote139 views1 answer
We are intrested to work with your organization
SQL