var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Select Nth largest record - How to?
How do i select first name of the lets say 6th highest salary of an employee?
is it use Select TOP statement?
p/s: I just want the 6th largest fname not the top 6. so it will only return one value.
Thank you in advance for your reply.
What about this idea?
select top 1 q.* from
(select top 6 * from table order by salary desc) as q
order by q.salary asc