Using Sql How Can We Copy All The Data Of A Table And Insert #94
Using SQL, how can we copy all the data of a table and insert into in a different table if both the tables has same attributes?
This multiple choice question (MCQ) is related to the book/course gs gs115 Structured Query Language. It can also be found in gs gs115 SQL Statements - SQL Insert Into Statement - Quiz No.1.
Using SQL, how can we copy all the data of a table and insert into in a different table if both the tables has same attributes?
INSERT INTO first VALUES SELECT * FROM second;
INSERT INTO first SELECT * FROM second;
INSERT INTO first COPY SELECT * FROM second;
INSERT INTO first FROM second;