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 vote293 views1 answer
Mysql count multiple columns in one query
SQL
3 votes305 views2 answers
How to load files in mysql
SQL
6 votes323 views2 answers
Postgresql database url
SQL
7 votes344 views1 answer
Show line number in sql server
SQL
1 vote296 views2 answers
Sql select only first occurrence
SQL
1 vote312 views1 answer
Sql server 2012 query history
SQL
0 vote327 views1 answer
Load data infile mariadb slow
SQL
0 vote309 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
0 vote309 views2 answers
Alter table add multiple columns mysql
SQL
1 vote309 views1 answer
Oracle drop job if exists
SQL