Intermediate
SQL
Q66 / 100
What does "INSERT INTO table (cols) SELECT cols FROM other_table" accomplish?
Correct! Well done.
Incorrect.
The correct answer is B) It inserts rows into "table" using the results of a SELECT query from "other_table", copying data between tables
B
Correct Answer
It inserts rows into "table" using the results of a SELECT query from "other_table", copying data between tables
Explanation
INSERT ... SELECT populates a table directly from the result set of another query, useful for bulk copying or transforming data between tables.
Progress
66/100