FunctionsWindow

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.

rank(…) → UInt64

Kind · window

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.

Part of the Window family.

percent_rank

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

row_number

Returns the 1-based row number of the current row within its partition, according to the window ORDER BY.