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 vote145 views2 answers
Return the number of records in a single table mysql
SQL
1 vote161 views1 answer
Oracle check table lock
SQL
0 vote131 views1 answer
Mysql workbench format date
SQL
7 votes144 views6 answers
Group_concat in mysql
SQL
0 vote126 views2 answers
Functions with parameters SQL
SQL
9 votes124 views2 answers
Get first 3 letters in sql
SQL
0 vote290 views1 answer
Get first match in each group mysql query
SQL
0 vote157 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote132 views1 answer
Sqlite select split string
SQL
0 vote134 views1 answer
Cannot pip install mysqlclient
SQL