Funky GROUP BY

[Ruslan Zasukhin]

On 10/11/06 7:41 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

>> Where only one field is referenced in the GROUP BY clause. I've got a HUGE
>> select statement in my actual code, and repeating every field in the GROUP
>> BY is very cumbersome. Is there a shortcut? Any help figuring this out would
>> be appreciated.
> 
> Again, please read carefully error message.

More examples:

SELECT 
    f1, f2, f3   -- this fields ARE NOT under aggregative functions
                 -- so they MUST BE listed in GROUP  BY
    SUM(f4),     -- no need for GTOUP BY
    AVG(f5+f6)   -- no need for GTOUP BY

FROM T

GROUP BY 
    f1, f2, f3



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]