QA – Placement Quizzes | SP Contest 2 | Question 4

Which of the following statement is used to copy data from one table and insert into another ?
(A) SELECT AND INSERT INTO
(B) INSERT INTO AND SELECT
(C) SELECT FROM AND INSERT INTO
(D) INSERT INTO SELECT

Answer: (D)
Explanation: The INSERT INTO SELECT statement copies data from one table and inserts it into another table.
Example query :
INSERT INTO table1
SELECT * FROM table2
WHERE condition;
Quiz of this Question