/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

2 votes119 views1 answer
Sql server find table name
SQL
0 vote122 views1 answer
Mysql disable query caching
SQL
0 vote127 views2 answers
Find lowest number in sql
SQL
0 vote126 views1 answer
Will graphql replace sql
SQL
0 vote153 views1 answer
Mariadb hours between two dates
SQL
0 vote138 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote135 views1 answer
Duplix print in Smartforms
SQL
8 votes135 views1 answer
Oracle search text in all packages
SQL
1 vote115 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote135 views1 answer
Select distinct after join
SQL

Share