Re: group by clause ordering

Thorsten Kettner wrote:
On 27 Apr., 11:32, Gints Plivna <gints.pli...@xxxxxxxxx> 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

Not mine which is why I didn't want to answer without seeing a real
SQL statement. Among the variations are:

CUBE
GROUP_ID
GROUPING
GROUPING SETS
ROLLUP
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • Re: group by clause ordering
    ... You get the same groupings, no matter if ... you group by a first and then by b or vice versa. ... Rollup had totally slipped my mind ...
    (comp.databases.oracle.misc)
  • Re: Whew! Great holiday! But where?
    ... How long do you think the union will survive, as a matter of interest? ... independent nations, some connected to each other in groupings like the ... that fails we fragment into smaller groupings. ...
    (uk.local.cumbria)