View Single Post
  #16 (permalink)  
Old 05-20-2008, 12:02 PM
Vishal
 
Posts: n/a
Default ANY answer. Re: i want to get the third highest salary from a table?

y go in for such complex query..try this

[sql]select min(Emp_Sal) from Employee_Test where Emp_Sal in
(select distinct top 2 Emp_Sal from Employee_Test order by Emp_Sal desc)[/sql]

Vishal
Reply With Quote