The SQL SELECT INTO statement basically for the use in many fields and It can be used to create backup copies of tables.
The SELECT INTO statement is use for the selects data from one table and It can also be inserts it into a different table.
The SELECT INTO statement is mostly use for the backup copies of tables.
Syntax : SELECT * INTO new_table_name [IN externaldatabase] FROM old_tablename
We can select only the columns we want into the new table :
SELECT column_name(e)I NTO new_table_name [IN externaldatabase] FROM old_tablename