martin.agren wrote:

> 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.

Neat idea perhaps, but 1) it would be better to get this keyword into
the standard than to have a non-standard thing in FB, and 2) the
original poster wasn't primarily complaining about too much typing but
risk of hitting the max sort key size, which your suggestions doesn't help.

Kjell
--
------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64


[Non-text portions of this message have been removed]