Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: group by clause ordering
On 27 Apr., 11:32, Gints Plivna <gints.pli..._at_gmail.com> wrote:
> > Marie, no, it is not possible to get other resulting rows by only
> > changing the group by order. You get the same groupings, no matter if
> > you group by a first and then by b or vice versa. And as all
> > aggregation (min, max, count, ...) is done per group, you definitely
> > get the same result rows.
>
> Yea. But things start to differ of course if you are using for example
> rollup, because then subsums are calculated for group by clause
> starting from right to left.
Good point. Rollup had totally slipped my mind Received on Fri Apr 27 2007 - 05:58:04 CDT