ROW_NUMBER () OVER ([PARTITION BY value_exp, ... [ n ]] order_by_clause) -- OVER - Specify the order of the rows. -- ORDER BY - Provide sort order for the records.