What happens to the shared row?

Question

Accepted Answer

UNION combines two result sets and removes duplicate rows. Bob appears in both tables but the result shows him only once. UNION ALL would keep both copies of Bob and return 4 rows. The two queries in a UNION must have the same number of columns and compatible data types.