row_number

Numbers the current row within its partition starting from 1.

Syntax

For more detail on window function syntax see: Window Functions - Syntax.

Returned value

• A number for the current row within its partition. UInt64.

Example

The following example is based on the example provided in the video instructional Ranking window functions in ClickHouse.

Query:

Result: