Answered by : comfortable-cassowary-rx2dxg0c368e

ROW_NUMBER() OVER (ORDER BY 'Column_Name' DESC) as ROW_NUMBER
select ROW_NUMBER() OVER(PARTITION BY WorkOrderID ORDER BY WorkOrderID ASC) AS Row#, * from TableName

Source : https://stackoverflow.com/questions/961007/how-do-i-use-row-number | Last Update : Wed, 23 Jun 21

Answered by : jealous-jackal-sjc0j0z1323g

SELECT
   ROW_NUMBER() OVER ( ORDER BY first_name
   ) row_num,
   first_name,
   last_name,
   city
FROM
   sales.customers;

Source : https://www.sqlservertutorial.net/sql-server-window-functions/sql-server-row_number-function/ | Last Update : Sat, 11 Apr 20

Answered by : gentle-gerbil-ai1q9y1arle2

 SELECT ROW_NUMBER() OVER (	ORDER BY first_name ) row_num, first_name, last_name, city
FROM sales.customers;

Source : https://www.sqlservertutorial.net/sql-server-window-functions/sql-server-row_number-function/ | Last Update : Mon, 30 Nov 20