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

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