Database Developer Interview Question:

Explain me the SELECT INTO statement?

Submitted by: Muhammad

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;
Submitted by: Muhammad