copy data from one table to another in sql

SQL SELECT INTO SELECT

SQL SELECT INTO statement copies data from one table into new table.

SQL INSERT INTO SELECT statement selects data from one table and insert it into another table.