SELECT INTO statement allows you to create a new temporary or permanent table populated with the results of the defined SELECT statement. You can select all columns or defined the specific columns and you can use WHERE clause or JION clauses with your SELECT statement.
The SELECT INTO statement is most often used to create backup copies of tables.
Let's see examples: