The ROW_NUMBER Analytic function is used to provide consecutive numbering of the rows in the result by

Fantastic news! We've Found the answer you've been seeking!

Question:

The ROW_NUMBER Analytic function is used to provide consecutive numbering of the rows in the result by the ORDER selected for each PARTITION specified in the OVER clause. It will assign the value 1 for the first row and increase the number of the subsequent rows.