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