SQL code copied to buffer

Task 26:

Difference between UNION and UNION ALL

What is the difference between UNION and UNION ALL?

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

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.

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

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

Tutorial

The check result will appear here.

Hi! Could we please enable some services and cookies to improve your experience and our website?

Privacy & Cookie Policy.