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.

Drivers & protocol

Choose a NYXDB client and design explicit connection, retry, streaming-termination, and version-compatibility behavior for the pre-GA wire protocol.