FunctionsWindow

cume_dist

Returns the fraction of rows in the partition with ORDER BY values less than or equal to the current row’s value.

cume_dist(…) → Float64

Kind · window

Returns the fraction of rows in the partition with ORDER BY values less than or equal to the current row’s value.

Part of the Window family.

Window

12 Window functions in the NYXDB native function registry, with signatures, briefs, and measured medians where available.

dense_rank

Returns the rank of the current row within its partition; ties receive the same rank and ranks increase by 1 for each distinct ORDER BY value.