ROW_NUMBER function

The row_number function assigns a sequential integer to each row in the data set. This function is typically used to generate a unique identifier for each row, which can be useful for ranking, pagination, and identifying specific rows in ordered datasets.

Syntax

row_number()

Usages

row_number()