Re: Group by question ...

"Oraclion" <inferno74_at_caramail.com> wrote in message 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 ?

Suppose you have:

A B F
-- -- --
11 1 10
1 11 11

Then, what result of

SELECT A,B sum(F) from Table group by A || B

would you expect?

A B F
-- -- --
11 1 10
1 11 11

(aka group by A, B) or

A || B F
------ --
111 21

(aka select A || B)? Received on Tue Nov 05 2002 - 20:00:49 CST