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.