Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    164

    Unanswered: need to get top 50 records only

    I did a query to get some info, but I only want the top 50 records to be displayed. How would I go about doing this?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    select top 50 .... [ rest of query ]
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jan 2004
    Posts
    164

    top 50 records

    Originally posted by r937
    select top 50 .... [ rest of query ]
    Thanks man. It had been a while sinse I had used access. I saw the dropdown box on the toolbar that lets you select either all records, a certain percentage or whatever number you wanna return. Thanks once again.

Posting Permissions

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