Thread: i want to get the third highest salary from a table?
View Single Post
  #11 (permalink)  
Old 04-22-2008, 06:39 AM
supriya
 
Posts: n/a
Default ANY answer. Re: i want to get the third highest salary from a table?
[sql]select TOP 1 salary from Employee( select distinct top 3 salary from employee ORDER BY DESC) a ORDER BY salary[/sql]
Reply With Quote