/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 vote105 views2 answers
Postgresql list columns
SQL
11 votes113 views2 answers
Docker create postgres db
SQL
0 vote120 views1 answer
Set open file limit mac catalina mysql
SQL
0 vote138 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote123 views1 answer
Where field is null sql knex
SQL
39 votes121 views5 answers
Sql drop column
SQL
0 vote120 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote105 views1 answer
Postgresql regular expression special characters
SQL
0 vote126 views1 answer
Sql ignore
SQL
8 votes114 views2 answers
Mysql query dates between two dates
SQL

Share