/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

1 vote269 views1 answer
How to run sql script
SQL
0 vote326 views1 answer
Postgress append string in select
SQL
1 vote331 views1 answer
Sysdate in sql
SQL
0 vote314 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote368 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
1 vote359 views1 answer
Sql server delete top 1000
SQL
0 vote339 views1 answer
Transalations from sql to Linq count and group by
SQL
1 vote336 views1 answer
Sql first
SQL
2 votes337 views1 answer
Sql update from different table
SQL
0 vote339 views1 answer
Mysql where in keep order
SQL

Share