Select TOP five

Results 1 to 2 of 2

Thread: Select TOP five

  1. #1
    Join Date
    Dec 1969

    Default Select TOP five

    When selecting the top five records from a table, what happens if there were only two. I know the two will be displayed but does this tax the database? If so, how to avoid that?

  2. #2
    Join Date
    Dec 1969

    Default RE: Select TOP five

    Select top 5 returns "Up to a max of 5 records"<BR>It can&#039;t select records that dont exist.<BR><BR>Just be sure you test for eof then your ok...<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