select top 20 records

Results 1 to 2 of 2

Thread: select top 20 records

  1. #1
    yls Guest

    Default select top 20 records

    Hi, i have two problems with the sql statements.<BR><BR>One is how to return a only 20 record sql query?<BR><BR>Two is how to randomly return records?<BR><BR>thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: select top 20 records

    You&#039ll find the random query answered on (and if that&#039s no good,<BR><BR>the other<BR><BR>SELECT TOP 20 * FROM table<BR><BR>j<BR>

Posting Permissions

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