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: newbie problem with analytic function

Re: newbie problem with analytic function

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Thu, 17 Aug 2006 11:04:38 +0200
Message-ID: <44e432d4$0$1393$9b4e6d93@newsspool3.arcor-online.net>


Khurram schrieb:
> I think order by clause dont cause for cummulative sum or running
> total,whenever the
> order_by_clause results in identical values for multiple rows, the
> function returns the
> same result for each of those rows.
>
>
> Khurram
>
> fitzjarrell_at_cox.net wrote:
>> ravi.superiors_at_gmail.com wrote:
>>> Mark D Powell wrote:
>> David Fitzjarrell
>

I think, you are wrong on it and David correct. Cumulative sum is caused by implicit windowing_clause (default - rows between unbound preceding and current row), which in turn is impossible to define without an order_by_clause in analytic_clause. So, there is clear dependency: order_by_clause implies windowing_clause which causes the cumulative results. Can be looked at http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14223/analysis.htm#sthref1725

Best regards

Maxim Received on Thu Aug 17 2006 - 04:04:38 CDT

Original text of this message

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