Rank/Dense_Rank - What function am I looking for?
From: Ethan Post <post.ethan_at_gmail.com>
Date: Fri, 3 Apr 2020 15:30:11 -0500
Message-ID: <CAMNhnU2ukxBLkd1phsDV=+4-S0Gm2+miK7hHVB2NsHjMbkX+Cg_at_mail.gmail.com>
I have a data set with groups of 40 rows. I need to rank 1-40 in each set for charting order by amount. In some cases amounts are all the same or some are. I still need to order 1-40 without any skips or duplicates. I can write a process that does this but thought there was a function for it. Rank and Dense Rank don't work because you get duplicate ranks when amount is the same. Maybe doesn't exist. Just checking.
Date: Fri, 3 Apr 2020 15:30:11 -0500
Message-ID: <CAMNhnU2ukxBLkd1phsDV=+4-S0Gm2+miK7hHVB2NsHjMbkX+Cg_at_mail.gmail.com>
I have a data set with groups of 40 rows. I need to rank 1-40 in each set for charting order by amount. In some cases amounts are all the same or some are. I still need to order 1-40 without any skips or duplicates. I can write a process that does this but thought there was a function for it. Rank and Dense Rank don't work because you get duplicate ranks when amount is the same. Maybe doesn't exist. Just checking.
Thanks,
Ethan Post
FarmPulse360.com
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 03 2020 - 22:30:11 CEST