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 vote137 views1 answer
Mysql read row
SQL
0 vote164 views1 answer
To Create directory
SQL
0 vote137 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
1 vote160 views2 answers
Drop table with constraints
SQL
0 vote166 views1 answer
Pl sql search in all packages
SQL
0 vote132 views1 answer
Oracle list subpartitions
SQL
1 vote227 views1 answer
Mysql monthname
SQL
6 votes156 views2 answers
Difference between join vs union
SQL
0 vote151 views1 answer
Alter table change default
SQL
0 vote148 views1 answer
Sort by last two number sql
SQL