SQL – Select Into

Spread the love

Select into – Copy a table or columns into a new table

Brand Table

PRODUCTTYPEQTYSALES
NIKESHOES107599
REEBOKTSHIRT181200
FILASHOES86000
PUMARUNNING SHOES165000

Copy all the table from Existing Table

SELECT * INTO ALL_COLUMNS_BRAND
FROM
BRAND

Copy particular columns from Existing Table

SELECT PRODUCT , QTY , SALES
INTO ALL_COLUMNS_BRAND
FROM
BRAND

COPY A TABLE AND COLUMNS

 

 

 

 

sql copy valuesvalues search keyword
copy values from table search keyword
copy values into table sql search keyword
copy values into table search keyword
copy values into a table search keyword
copy records into a table search keyword
copy values command sql search keyword
select copy values by sql query search keyword
sql query find copy valuesfrom table search keyword
sql copy values into table search keyword
sql copy values into a table search keyword
sql copy records into a table search keyword
sql copy data into a table search keyword
sql copy data into table search keyword
sql copy data into existing table search keyword