Re: Rank/Dense_Rank - What function am I looking for?

That's it! Thanks!

On Fri, Apr 3, 2020 at 3:34 PM Andy Sayer <andysayer_at_gmail.com> wrote:

> It sounds like you’re after plain old row_number.
>
> Thanks,
> Andrew
>
> On Fri, 3 Apr 2020 at 21:33, Ethan Post <post.ethan_at_gmail.com> wrote:
>
>> 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-l