copy column from same table

Table 1

Col1

Col2

Col3

New column Col4 added

Col4 has same data col2

Method

Update table1 set Col4=col2

Create table as 

Insert into table2( col1,col2,col3,col2)

Rename