/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 vote262 views1 answer
Declare variables sql
SQL
0 vote296 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote254 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote235 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote279 views1 answer
Oracle sql developer closed connection
SQL
3 votes290 views6 answers
Jwt laravel
SQL
0 vote279 views1 answer
Mysql remove last character
SQL
1 vote267 views2 answers
Drop function in sql
SQL
5 votes233 views1 answer
Mongodb vs
SQL
1 vote262 views1 answer
Sql Split string function
SQL

Share