>hi all
>I have a table with 3 columns one is customer name and the other itemid and item color and I want to know for each customer how many items he has and which color how can I make it in a sql command
>
>
>thanx
Try these statements, depending on the level of grouping you wish:
Select Name,Color,count(*) as Count from MyTable group by name,Color
Select Name,count(*) as Count from MyTable group by name
Regards
Jose