SELECT TOP

  • Thread starter Thread starter mscertified
  • Start date Start date
M

mscertified

If I say 'SELECT TOP 5' and the result set returns less than 5 rows, do I get
an error?

I looked in Access SQL help and it did not say.
 
Pretty sure that "TOP 5" translates to "limit results to no more than 5".
So if only 3 records meet the remaining criteria, you would get those 3
records and no error.
 
Back
Top