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 vote226 views1 answer
On update current_timestamp jpa
SQL
0 vote192 views1 answer
Oracle sql developer script output limit
SQL
0 vote238 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
4 votes247 views3 answers
Sql drop primary key
SQL
0 vote228 views1 answer
Postgres 11 add primary key
SQL
0 vote242 views2 answers
Search stored procedures
SQL
0 vote238 views2 answers
Create fulltext index mysql
SQL
0 vote243 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
2 votes231 views1 answer
How to make insert script from table in SQL server
SQL
14 votes257 views3 answers
Inner join sql oracle
SQL