/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 vote268 views1 answer
Mysql alter decimal precision
SQL
0 vote309 views1 answer
Plpgsql create function
SQL
9 votes273 views2 answers
Nosql databases
SQL
0 vote271 views1 answer
Csv to sqlite python
SQL
0 vote271 views1 answer
Insert ip address in mysql
SQL
0 vote266 views1 answer
Into operator in sql
SQL
0 vote273 views1 answer
Where date major today mysql
SQL
0 vote220 views1 answer
Print sum of values sql
SQL
0 vote286 views1 answer
Mysql 3 months ago
SQL
13 votes279 views5 answers
Alter table query sql server change column
SQL

Share