SQL question

[inusrat]

Hi,


I have a table called "products" that has suppose hundred products in it that belong to 10 different barnds.

I need ro run an SQL that gives me total number of products in each brand.

Some thing like they are doing here,

http://www.sntradersonline.com/products.cfm

How can I do That?

Thanks

http://www.786Marriage.com

http://www.amasspharma.com

http://www.ambdex.com

 

[r937]

select brand, count(*) as products_per_brand
from products group by brand

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[inusrat]

thanks I will try that .........

http://www.786Marriage.com

http://www.amasspharma.com

http://www.ambdex.com