Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Group by question ...
Hi,
When you use a function like sum,... then you have to put all other columns into the group by clause or use them with a function like min,...
In my opinion there is no way to do this like you want with the
concatenation.
Just
select A || B || C, sum(F) from Table group by A || B || C
should work in your statement.
Rgds
Dirk
"Oraclion" <inferno74_at_caramail.com> schrieb im Newsbeitrag
news:aq8hoh$f5t$1_at_news-reader11.wanadoo.fr...
> HI
>
> 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:15:12 CST