Thread: i want to get the third highest salary from a table?
View Single Post
  #10 (permalink)  
Old 04-17-2008, 06:51 AM
Unregistered
 
Posts: n/a
Post ANY answer. Re: i want to get the third highest salary from a table?
[sql]Select Empname,salary From ##employees A Where 3=(select Count (distinct(salary)) From ##employees B
Where B.salary>=a.salary)[/sql]
Reply With Quote