>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