SQL Quiz: Difference between UNION and UNION ALL

Task 51:

What is the difference between UNION and UNION ALL?

When combining data, UNION ALL returns all rows, and UNION returns only unique rows.

In UNION, the list of fields of the combined data must be identical, but in UNION ALL this is not necessary.

UNION removes NULL values when combining data, while UNION ALL leaves them.

UNION joins only those records that have matches, and UNION ALL joins all records without exception.

Mark all correct answers and click the "Check!" button

Login