How do I get the results of a SELECT, and count the results at the
same time?

I've tried:

SELECT productname, COUNT(*) AS cnt from URL

but this gives:
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP
columns is illegal if there is no GROUP BY clause

Help!