I have created a table and populated some records. But, I missed to populate the serial number on RyotNo column.
How to populate sequence number on these 5 records(101 to 105) - LOOP should not be used here...!
Is there any simple UPDATE ?
RyotNo RyotName Phone
-----------------------------
NULL ABC1 12345
NULL EFG1 67890
NULL JKL1 13567
NULL MNO1 24680
NULL QWS1 67981
thank you