FunctionsWindow

row_number

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

row_number(…) → UInt64

Kind · window

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

Part of the Window family.

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.

Operations

Deploy and run NYXDB — deployment, storage pools, the memory governor, observability system tables, and profiling.