>I am trying to understand what the Group by clause in an SQL select statement does. Can someone explain this in simple terms?
>
>Thanks

Combine all like items into a single row that contains the SUM, or the COUNT, etc.. Distinct items will each have their own row in the result set.