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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

"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,451 views