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
|