Re: New Window Function: ROW_NUMBER_DESC() OVER() ?

On Tuesday, January 16, 2024, Maiquel Grassi <grassi(at)hotmail(dot)com(dot)br> wrote:

> Hello David, how are you?
>
> Firstly, I apologize if I wasn't clear in what I intended to propose. I
> used a very specific example here, and it wasn't very clear what I really
> wanted to bring up for discussion.
>
> I understand that it's possible to order the "returned dataset" using
> "order by ... desc."
>
>
It is, but it is also possible to order a window frame/partition by
specifying order by in the over clause. Which is what I showed, and what
you should try to use. That orders the enumeration, you can still order,
or not, the output dataset.

> I don't have a base column to use for "order by," and I also can't use
> CTID column.
>

Then you really don’t have an ordering in the data itself. This is unusual
and not really worth adding a new function to deal with.

>
> How can I do this without using my reversed enumeration "row_number desc"
> function?
>

Count() over() - row_number() over()

Please don’t top-post replies, in-line and trim like I’m doing.

David J.

P.s. if you really don’t care about logical order you probably should just
let your front-end deal with it.