Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: group by clause ordering
Thorsten Kettner wrote:
> On 27 Apr., 11:32, Gints Plivna <gints.pli..._at_gmail.com> wrote:
>> 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.orgReceived on Fri Apr 27 2007 - 09:40:59 CDT