/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 vote272 views1 answer
Oracle first row
SQL
10 votes281 views4 answers
Join with multiple conditions sql
SQL
2 votes265 views2 answers
Function in sql
SQL
0 vote315 views2 answers
How to get max from each department in sql
SQL
0 vote288 views1 answer
What is the difference between now() and current_date()?
SQL
22 votes312 views3 answers
Year format in date mysql
SQL
0 vote338 views1 answer
Sql alternative to max statement
SQL
1 vote286 views1 answer
Python clean sql string
SQL
4 votes278 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote280 views1 answer
Events not working db
SQL

Share