Check following query
UPDATE myTable
SET
column1 = firstrow.column1,
column1 = firstrow.column1,
column1 = firstrow.column1
FROM
(
SELECT
column1,column2,column3
FROM MyTable
WHERE
RECNO=1
) firstrow
where RECNO<> 1
That should serve the purpose
Hope that helps
Milind