Posts tagged with:
rowid rownumber identity rows
-
Create row numbers based on the rows available in a table from sanjeevdas123 232 days old
SELECT ROWID=IDENTITY(int,1,1) , EMPID, FNAME, LNAME INTO EMPLOYEE2 FROM EMPLOYEE ORDER BY EMPID
