Re: newbie problem with analytic function

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Thu, 17 Aug 2006 11:13:10 +0200
Message-ID: <44e434d4$0$20032$9b4e6d93@newsspool4.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

Sorry, just reread your post, maybe i misunderstood you at first read. Yes, the cumulative sum will remain the same in case of duplicates. But you can specify more than one order_by expression to eliminate the duplicates (only for ROWS keyword) .

Best regards

Maxim Received on Thu Aug 17 2006 - 04:13:10 CDT