> > >

SQL MCQs

How can you insert several records in TABLE1 that already exist in TABLE2?

insert into TABLE1 (FIELD1) values (select FIELD2 from TABLE2)

insert into TABLE1 (FIELD1) select FIELD2 from TABLE2

insert into TABLE1 (FIELD1) values (TABLE2.FIELD2)

insert into TABLE1 (FIELD1) select FIELD2 , FIELD3, FIELD4 from TABLE2

Answer

Correct Answer: insert into TABLE1 (FIELD1) select FIELD2 from TABLE2

Explanation:

Note: This Question is unanswered, help us to find answer for this one

SQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it