sql data copy from one table to another

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