You can use a SELECT and an INSERT in the same statement to insert multiple rows into a table at one time.

Question

Quizplus · Accepted Answer

A SELECT statement can be used to retrieve data from one or more tables, and an INSERT statement can be used to add new rows to a table. By combining the two statements into a single statement, it is possible to insert multiple rows into a table at once based on the selected data. This can be achieved using the INSERT INTO SELECT statement in SQL.

You Can Use a SELECT and an INSERT in the Same