Getting count for each product and its name

[cad4321]

Hi,

I am trying to get total number of products in different departmental stores and i also want to get the name of the product. I have this query.

Select count(prod) as cnt, prodname from distribution
not working

[Chand]

use group by
so
Select count(prod) as cnt, prodname from distribution group by prodname
you can't use count without group by