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

Home -> Community -> Usenet -> c.d.o.misc -> Re: group by clause ordering

Re: group by clause ordering

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 27 Apr 2007 07:40:59 -0700
Message-ID: <1177684858.389730@bubbleator.drizzle.com>


Thorsten Kettner wrote:

> 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

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_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Apr 27 2007 - 09:40:59 CDT

Original text of this message

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