Re: newbie problem with analytic function

Mark D Powell wrote:
> In general the order by within the partition exists to order the data
> for the purpose of calculationg the partition results. In your example
> the use of the order by results in the sum displayed being the
> cumulative sum of the salary within a department. In the second
> example where no order by clause exists within the partition by clause
> the displayed sum for all rows within a department is the department
> total.
>
> You should always include the Oracle edition and version in a post
> since the response may need to vary depending on this.
>
> HTH -- Mark D Powell --

thanx mark for yours response but a little confusion it is not written anywhere in oracle
doc for analytic function that what you are syaing ,oracles doc did not mention to force
order by clause for cummulative claculation for correct result.Still its paining whats the
role of order by clause??

sorry,i am using  

Oracle9i Enterprise Edition Release 9.2.0.1.0

ravi Received on Wed Aug 02 2006 - 23:55:09 CDT