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 vote101 views1 answer
Order by monthly in sql
SQL
2 votes130 views3 answers
Postgres create view
SQL
0 vote116 views1 answer
Tsql default value when no value returned by query
SQL
0 vote130 views1 answer
Sql server alter table column nullable
SQL
9 votes116 views4 answers
SQL Date Format
SQL
4 votes115 views2 answers
Truncate oracle
SQL
19 votes108 views6 answers
Laravel sql query
SQL
1 vote121 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
4 votes154 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote79 views1 answer
Hangfire clean script
SQL