Skip to Main Content

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!

What would cause DENSE_RANK not to take care of numerical "ties"?

819570Sep 2 2011 — edited Sep 2 2011
Hi,

We're using Oracle 11.1.

I'm using an Analytic function to rank values in each "partition by" section.

Because there are numerical ties I'm using DENSE_RANK because it's supposed to take care of ties.

It's not.

The clause is simply
DENSE_RANK() OVER (PARTITION BY metric ORDER BY AEROBIC_EXERCISE)
It's just data coming from a sub query where you can see what the order should be and it's not. Has anyone ever seen this before?

What am I leaving out?

Thanks.
This post has been answered by JustinCave on Sep 2 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 30 2011
Added on Sep 2 2011
8 comments
363 views