rowNumber

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.