I have employee table containing salary column. I want to retrieve 3rd highest salary from the table. what would be the query for that? I can though of
select top (3) salary from emp orderby desc;
But I need only one result set. How can i do that??
View Complete Post