> > >

Microsoft SQL Server MCQs

Which of the following rules must be followed for combining the result sets of two queries by using UNION?

The number of columns must be same in all queries.

The order of columns must be same in all queries.

The data types of the columns of the queries must be compatible.

There should be at least one common column in the tables which are part of the UNION operation.

Answer

Correct Answer: The number of columns must be same in all queries.

Explanation:

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

Microsoft SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it