Skip to Main Content
Forums

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!

"FIRST_VALUE() OVER () vs MAX() DENSE_RANK FIRST OVER()

799879Jul 29 2011 — edited Jul 29 2011
I am trying to determine the differences between using the analytic function first_value vs using the DENSE_RANK FIRST OVER() style analytic function.

In particular, when is it appropriate to use one vs the other? Truthfully the DENSE_RANK FIRST OVER() seems like an much more flexible version of the first_value function.

Any enlightenment is much appreciated.
This post has been answered by Frank Kulash on Jul 29 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2011
Added on Jul 29 2011
9 comments
8,774 views