Select Into Statement in SQL
Simply, The SELECT INTO statement is used to copy data from one table into a new table.
SELECT INTO STATEMENT QUERY EXAMPLE; HOW TO COPY DATA FROM THE OLD TABLE TO THE NEW TABLE
(*) the symbol used to select all data from the table and the WHERE condition used to specify which rows to copy, for more understanding see the below-mentioned example:
SELECT * INTO New_Table
FROM Old_Table
WHERE condition;
OR ******************************
Select queries are used to copy some select columns only and the WHERE condition is used to specify which rows to copy, for more understanding see the below-mentioned example:
SELECT column_1, column_2, column_3, ...
INTO New_Table FROM Old_Table
WHERE condition;