If a table already exists,what command would you issue to add copies of existing rows from one table to the other?
A) INSERT command with an UPDATE clause
B) INSERT command with a SET clause
C) INSERT command with a subquery
D) none of the above

Question

If a table already exists,what command would you issue to add copies of existing rows from one table to the other?​
A) ​INSERT command with an UPDATE clause
B) ​INSERT command with a SET clause
C) ​INSERT command with a subquery
D) ​none of the above

Quizplus · Accepted Answer

To add copies of existing rows from one table to the other, the INSERT command with a subquery can be used to select the rows from the original table and then insert them into the target table. The subquery can be used to specify which rows to select and can also include any necessary filters or conditions.

If a Table Already Exists,what Command Would You Issue to Add