rowNumber

fun rowNumber(): WindowFunctionExpression<Int> (source code)

The row_number window function, translated to row_number() in SQL.

Return the number of the current row within its partition. Row numbers range from 1 to the number of partition rows.
ORDER BY affects the order in which rows are numbered. Without ORDER BY, row numbering is nondeterministic.

Since
3.6.0