/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 vote193 views1 answer
Get time component of datetime sql
SQL
2 votes187 views1 answer
How to add where command in update comand with joins
SQL
0 vote180 views1 answer
Cara menampilkan user di mysql terminal
SQL
1 vote196 views1 answer
Sql group by error
SQL
10 votes207 views3 answers
Sql select between two dates
SQL
49 votes303 views6 answers
Mysql add column to table
SQL
0 vote246 views2 answers
Search stored procedures
SQL
14 votes204 views4 answers
Import database through command line
SQL
1 vote195 views1 answer
SQLite order random
SQL
0 vote245 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL

Share