Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Group By Questions..

Re: Group By Questions..

From: Tom Verhagen <tverhage_at_bart.nl>
Date: Fri, 1 Oct 1999 22:06:41 +0200
Message-ID: <7t33v8$c03$1@freyja.bart.nl>


Yes does affect the outcome if B and C and D is NOT a primary or unique key

Jimmy heeft geschreven in bericht <37F5DB19.5363BFB9_at_comp.polyu.edu.hk>...
>Hello all,
>
> Assume I have a table with column A, B, C and D.
>
> I wonder the following SQL statements will produce the same results:
>
> i) select B, C, D, avg(A) from AAA group by B, C, D;
> ii) select B, C, D, avg(A) from AAA group by B, D, C;
> iii) select B, C, D, avg(A) from AAA group by C, B, D;
> ....
>
> i.e. does the order of group by clause affect the final result (or
>performance, if any) of the SQL statement? Anyone knows white papers or
>documents discussing this issue?
>
>Thanks,
>Jimmy
>
>
>
>
Received on Fri Oct 01 1999 - 15:06:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US