Saturday, October 24, 2009

Get 3 Max Value

Select salary from (select salary from emp)a,(select salary from emp)b
where a.salary>= b.salary
Group by (b.salary)
having count(b.salary) = 3

No comments: