Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie problem with analytic function
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
![]() |
![]() |