/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

0 vote139 views1 answer
Sqlalchemy get ids
SQL
0 vote136 views3 answers
Sql drop all tables
SQL
1 vote125 views1 answer
Influxdb export to csv
SQL
0 vote135 views1 answer
Postgres where
SQL
3 votes128 views4 answers
Psql list tables in schema
SQL
0 vote127 views1 answer
Mysql select last 15 minutes
SQL
0 vote145 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote132 views1 answer
Oracle dynamic select into
SQL
8 votes131 views2 answers
Between operator
SQL
13 votes126 views6 answers
Current date sql
SQL

Share