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 vote264 views1 answer
How to reset the database value in SQL server
SQL
0 vote280 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
1 vote254 views2 answers
Sql drop multiple columns if exists
SQL
1 vote243 views2 answers
How to check username in mysql command line
SQL
0 vote274 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
0 vote266 views1 answer
Selecting duplicates
SQL
2 votes235 views2 answers
Select multiple tables mysql
SQL
0 vote270 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
9 votes282 views3 answers
Date format in sql
SQL
19 votes256 views4 answers
Rename database in sql
SQL