CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. August 11th, 1999, 07:20 AM #1
    muralirajan
    muralirajan is offline Junior Member
    Join Date
    Aug 1999
    Posts
    16

    SQL stateent to find 5th Highest salary


    Please send me the SQL Statement to find the Employee row who is getting the 5th highest salary?


    muralirajan
    Reply With Quote Reply With Quote
  2. August 11th, 1999, 07:26 AM #2
    Lothar Haensler
    Lothar Haensler is offline Elite Member
    Join Date
    May 1999
    Posts
    3,332

    Re: SQL stateent to find 5th Highest salary

    if you database supports the "SELECT TOP n"-Syntax (e.g. SQLServer 7) you can try "SELECT TOP 5 * FROM ... ".
    Since the return value can be more then 1 employee, you'd have to read all values.

    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




Click Here to Expand Forum to Full Width

Featured