What Is The Syntax Of Insert Into Select Statement #276
What is the syntax of INSERT INTO SELECT statement?
This multiple choice question (MCQ) is related to the book/course gs gs115 Structured Query Language. It can also be found in gs gs115 SQL Subqueries - SQL Insert Into Select - Quiz No.1.
What is the syntax of INSERT INTO SELECT statement?
Insert into select * from source_table, target_table Where condition;
Insert into target_table Select * from source_table Where condition;
Insert into select * from (source_table, target_table) Where condition;
select * from source_table Insert into target_table Where condition;