/SQL/3rd height salary sql

3rd height salary sql

N highest salary in sql

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP N salary
FROM #Employee
ORDER BY salary DESC
) AS temp
ORDER BY salary

7

Source: javarevisited.blogspot.com

3rd height salary sql

SELECT MIN(EmpSalary) from ( 
	SELECT EmpSalary from Employee ORDER BY EmpSalary DESC LIMIT 3 
);

0

Similar codes

0 vote122 views2 answers
Find Overlapping sql
SQL
7 votes129 views2 answers
Mysql get year from date
SQL
3 votes130 views1 answer
Oracle apex warning message
SQL
0 vote128 views1 answer
Order by with where clause in mysql
SQL
-1 vote146 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote122 views1 answer
Excute raw query
SQL
-1 vote136 views1 answer
Su: Authentication failure mysql
SQL
4 votes137 views5 answers
Primary key
SQL
5 votes150 views2 answers
Get columns number sql
SQL
10 votes130 views1 answer
Oracle dba_dependencies
SQL

Share