TOP CATEGORIES

×

What is select into statement?

A

Arvind Kumar A.K

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;

1 votes

Your Answer

Email: advertise@gdatamart.com

Donate: To Support US

© 2024 GDATAMART.COM (All Rights Reserved)