data copy from one table to another in sql

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