Group by question ...

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 5 Nov 2002 14:01:42 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702E1DD8C@lnewton.leeds.lfs.co.uk>

Hi Oraclion,

you need to do something like :

select ....
from ....
group by a,b,c,d,e

because none of them are columns upon which you have carried out an 'aggregate' function.

However, you can do this :

select a || b || c, d, e, sum(f)
from .....
group by a || b || c, d, e

but you still need to group by all the un 'aggregated' columns - so d and e must be in the group by.

HTH Regards,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Oraclion [mailto:inferno74_at_caramail.com] Posted At: Tuesday, November 05, 2002 1:49 PM Posted To: server
Conversation: Group by question ...
Subject: Group by question ...

I want to do

SELECT A,B,C,D,E, sum(F) from Table group by A || B || C;

It's not possible because A isn't a group by expression ! ok Is a way exists to do this ?

Bests regards
Oraclion Received on Tue Nov 05 2002 - 08:01:42 CST