FunctionsWindow

percent_rank

Returns the relative rank of the current row as a value between 0 and 1, computed from rank and the partition size.

percent_rank(…) → Float64

Kind · window

Returns the relative rank of the current row as a value between 0 and 1, computed from rank and the partition size.

Part of the Window family.

nth_value

Returns the value of an expression from the nth row of the current window frame. If n is out of range, returns NULL.

rank

Returns the rank of the current row within its partition; ties receive the same rank and the next rank is increased by the number of tied rows.