select into

"SELECT INTO" is a SQL statement used to create a new table from an existing table. The statement is used to copy the data from one table and insert it into a new table.

The syntax for the statement is as follows:

SELECT column1, column2, ...
INTO new_table
FROM existing_table
WHERE condition;

Here, "column1, column2, ..." are the columns that need to be copied from the existing table to the new table. "new_table" is the name of the new table that will be created. "existing_table" is the name of the table from which the data will be copied. "condition" is an optional clause used to filter the data that will be copied.

Note that the "SELECT INTO" statement is only used to create a new table. If you want to insert data into an existing table, you should use the "INSERT INTO" statement instead.