ROW_NUMBER() #

Windowing function that adds a sequentially-ordered row number field to a query’s results

SELECT
    ROW_NUMBER() OVER(
        ORDER BY <field>
    ) <name for the row number field introdcued>,
    <field>,
    <field>,
    ...
FROM <table>;

Thiw would bring in a row number column sequenced as 1, 2, 3, ….