/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 vote277 views1 answer
Sqlite referential integrity
SQL
0 vote316 views1 answer
How to install sql in anaconda
SQL
0 vote276 views1 answer
Sql view index
SQL
1 vote327 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
-1 vote279 views2 answers
Full join sql
SQL
16 votes316 views6 answers
Python sqlite
SQL
-1 vote295 views1 answer
How to switch user in mysql
SQL
0 vote283 views1 answer
How to save data in database in mysql node
SQL
1 vote285 views1 answer
What is intersect
SQL
10 votes317 views2 answers
Mysql alter add foreign key
SQL

Share