Answers for "create a row sql"

create row number in sql

SELECT t.A, t.B, t.C, ROW_NUMBER() OVER (ORDER BY t.A) as newId
  FROM dbo.tableZ AS t
  ORDER BY t.A;

Posted by: Guest on July-24-2020

Code answers related to "create a row sql"