How do you use data from certain columns of an existing table to populate a new table with a matching structure?
A) Place a SELECT command within an INSERT command.
B) Execute a CREATE TABLE command with an INSERT clause.
C) Copy the existing table and delete the unwanted columns.
D) Add an INSERT clause after the WHERE clause in a SELECT command.

Question

Quizplus · Accepted Answer

The Answer is A

How Do You Use Data from Certain Columns of an Existing