Select TOP 20

Scott Reynolds · Aug 28, 2004

Hello!

Could someone please tell me why this query does not show top 20 Products
ordered by Hits?

SELECT TOP 20 Id, ProductName, Hits
FROM Products
ORDER BY Hits DESC;

Thank you in advance!
Scott

Douglas J. Steele · Aug 28, 2004

What does it show? If there are more than 20 shown, that's because there
must be ties on Hits.

Arvin Meyer · Aug 28, 2004

I'd take the ID value out of the query. As long as it's there you can't
count the other fields.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Select TOP 20

Scott Reynolds

Douglas J. Steele

Arvin Meyer