SQL UNION vs UNION ALL

In both cases, columns on both sides of the union should have the same datatype.

UNION removes duplicates.
UNION ALL keeps duplicates.