/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

11 votes184 views1 answer
Get ddl materialized view oracle
SQL
0 vote213 views1 answer
Ubuntu connect to mssql database
SQL
0 vote186 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote179 views1 answer
Changer un mot de passe mysql
SQL
8 votes186 views6 answers
Sql insert
SQL
0 vote183 views1 answer
Subquery aggregation
SQL
2 votes219 views2 answers
Sql query to list all tables in a database sql server
SQL
5 votes196 views2 answers
Oracle rename table
SQL
7 votes216 views3 answers
Restore postgres database from sql file
SQL
2 votes177 views1 answer
Sql like variable
SQL

Share