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 vote225 views1 answer
Mysql sum with group by
SQL
0 vote218 views1 answer
If column value is null then in mysql
SQL
14 votes220 views3 answers
Sql trim from string
SQL
0 vote209 views1 answer
Trigger value from maltiple table to single table mysql
SQL
1 vote237 views1 answer
Postgresql if 0 then 1
SQL
14 votes236 views3 answers
Inner join sql oracle
SQL
1 vote191 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
0 vote203 views1 answer
Create table Statement Syntax in SQL Server
SQL
1 vote212 views2 answers
String to date postgres
SQL
0 vote212 views1 answer
Oracle flush Shared Pool
SQL