The SELECT INTO statement copies data from one table into a new table. The new table will be created with the column-names and types as defined in the old table. You can create new column names using the AS clause.

SELECT * INTO newtable FROM oldtable WHERE condition;