SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

USING DISTINCT IN FIRST_VALUE ANALYTIC FUNCTIONS

91334Nov 6 2002

When using distinct with an analytic functions it looks like the distinct is applied before the data is pass to the functions. Is this correct?

I quess what I'm asking for is the order of operation of the distinct command in a analytic function.

Thanks in advance.

Robert

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 10 2002

Added on Nov 6 2002

1 comment

752 views