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 vote151 views1 answer
Mysql foreach insert
SQL
0 vote146 views1 answer
Sql file in postgres with pgadmin
SQL
9 votes170 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote217 views1 answer
SQL query to verify the size of the table
SQL
1 vote145 views1 answer
Sql server find tables referenced foreign key
SQL
5 votes154 views2 answers
Mysql import gzip db
SQL
0 vote160 views2 answers
Athena drop partition
SQL
0 vote108 views2 answers
Sql query unique
SQL
3 votes153 views1 answer
Get all elements sql
SQL
12 votes161 views4 answers
How to check mysql version ubuntu
SQL