FunctionsWindow

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.

dense_rank(…) → UInt64

Kind · window

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.

Part of the Window family.

cume_dist

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

first_value

Returns the value of an expression from the first row of the current window frame.