Can I use… row_number()

Row_number() window function returns a distinct ordinal number for every row.

SELECT ROW_NUMBER() OVER (ORDER BY …)
  FROM …

Related

• Variants: without order by

• Similar functions: rank(), dense_rank(), percent_rank(), cume_dist().

• Product specific forms: rownum (pseudo column).

Normative References

The row_number() window function is defined in ISO/IEC 9075:2016-2 as part of optional feature T611, “Elementary OLAP operations”.