Answers for "select rownum sql"

SQL
0

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 "SQL"

Browse Popular Code Answers by Language