/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 vote102 views3 answers
Remove unique key from a table
SQL
0 vote110 views1 answer
Show function mysql
SQL
0 vote115 views1 answer
Postgresql not in alternative
SQL
0 vote114 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote152 views1 answer
Postgres extract number from string
SQL
0 vote116 views1 answer
Alter check command
SQL
0 vote107 views1 answer
Snap craft
SQL
3 votes106 views2 answers
Oracle grants
SQL
0 vote128 views1 answer
Calculer pourcentage mysql
SQL
0 vote117 views1 answer
How to run mysql in git bash
SQL

Share