Thread: Top 3rd value
View Single Post
  #6 (permalink)  
Old 12-17-2007, 11:44 AM
Ananthan
 
Posts: n/a
Default ANY answer. Re: Top 3rd value
select salary from E1 where (4-1)=(select count(distinct(salary)) from E2 where E2.salary>E1.salary).
Reply With Quote