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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Top with aggregate function 1
Remove Ties from a Top 5 query 10
Selecting top 5 2
Top 5 with grouping 1
Using TOP with SELECT 4
Top 5 by a GROUPing? 1
Top N Records on multiple fields 14
SELECT TOP N - Can N be variable? 2

Back
Top