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
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
Quiz of this Question
My Personal Notes arrow_drop_up
Please Login to comment...