to find the third highest row in a table (employee_test for e.g.)


[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