Results 1 to 3 of 3

Thread: how to write a query for 1st, 2nd, 3rd max salary

  1. 04-18-2006, 06:31 PM #1
    sgar
    sgar is offline Registered User
    Join Date
    Mar 2006
    Posts
    14

    how to write a query for 1st, 2nd, 3rd max salary

    employee table having columns employeeid, salary

    i want to write a query to get 1st, 2nd and 3rd max salary ?
    Reply With Quote Reply With Quote
  2. 04-19-2006, 02:16 AM #2
    russellb
    russellb is offline Registered User
    Join Date
    Apr 2006
    Posts
    30
    select top 3 employeeid, salary
    from tableName
    order by salary desc
    Reply With Quote Reply With Quote
  3. 04-19-2006, 10:16 AM #3
    sgar
    sgar is offline Registered User
    Join Date
    Mar 2006
    Posts
    14

    hi russelb

    I appreciate ur help
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules