Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    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.

  2. #2
    Join Date
    Jul 2002
    Village, MD
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts