Employee Name | Salary |
Emp 1 | 10000 |
Emp 2 | 13000 |
Emp3 | 12000 |
Emp 4 | 14000 |
Emp 5 | 15000 |
Saturday, July 24, 2010
Write a SQL query that display 4th max salary from the following table
Employee table
select min (Salary) from DW.Dimemployee where Salary in (select top 4 Salary from DW.Dimemployee order by Salary)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment