Post reply

Select Statement Returning the first 50 Records

  • May 21, 2004 at 8:16 am

    #111243

    Can somebody please give me the correct syntax to

    return the first 50 records using a SELECT Statement?

     

    Thanks

  • May 21, 2004 at 8:55 am

    #507304

    Use rowcount to limit to as many as you want, make sure you set rowcount to 0 to turn if off after you are done.

    Set RowCount 50

    Select * from tablename

    set rowcount 0

  • May 21, 2004 at 12:31 pm

    #507337

    Try this

    Select Top 50 * from DataTable

     

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply