> > >

MSBI MCQs

What is the difference between UNION and UNION ALL?

Union selects only unique row (data) from all queries and Union all selects all rows from all queries.

Union selects row (data) from all queries and Union all selects all rows from all queries.

Union selects only unique row (data) from all queries and Union all selects rows from all queries.

Union selects row (data) from all queries and Union all selects rows from all queries.

Answer

Correct Answer: Union selects only unique row (data) from all queries and Union all selects all rows from all queries.

Explanation:

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

MSBI Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it