What Is The Basic Syntax Used In Sql To Combine The Resultset #230
What is the basic syntax used in SQL to combine the result-set of two tables?
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 Joins - SQL Union - Quiz No.2.
What is the basic syntax used in SQL to combine the result-set of two tables?
Select column_list From table1 Select column_list From table2 UNION;
Select column_list From table1 UNION Select column_list From table2;
Select column_list UNION Select column_list From table1;
Select column_list From table1 COMBINE Select column_list From table2;