/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 vote99 views1 answer
Sql select all from one table and one column from another
SQL
0 vote104 views1 answer
Azure sql server check foreign key
SQL
3 votes105 views3 answers
How to add month in update sql
SQL
2 votes114 views1 answer
How to create sql database
SQL
0 vote104 views1 answer
Char vs varchar2 in sql
SQL
2 votes113 views2 answers
Mysql does sentence contain word
SQL
0 vote113 views1 answer
Get last date join sql
SQL
0 vote92 views1 answer
How to find top 3 salary in sql
SQL
0 vote107 views1 answer
Joomla execute raw sql
SQL
0 vote116 views1 answer
WHERE not regex in SQL
SQL

Share