ROW_NUMBER

ROW_NUMBER is a SQL function that assigns a unique integer value to each row in a result set, facilitating ranking and partitioning data.