I've often wondered why we need it at all when it contains all the non
aggregate fields in the select?

Regards
Paul

>
> I have often asked myself why the group by syntax is so ineffective.
>
> Couldnt a short hand (non standard) addition be
>
> Select grouped Description, count(Id) Count
>
> All that is required is a new keyword, that internally picks all non
> aggregate columns and adds them to a group by statement.
>
> The obvious benefit would of course appear when we have a large number of
> those non aggregate columns.
>
> /M
>