SQL Insert duplicate data in to same table
SQL Select and Insert statement
Insert into <MyTable> Select * from <MyTable>
Or
Insert into <MyTable> Select ID,Name from <MyTable>
SQL Select and Insert statement
Insert into <MyTable> Select * from <MyTable>
Or
Insert into <MyTable> Select ID,Name from <MyTable>