UNION and UNION ALL

Concepts: sqlUnion

UNION Comparison and Examples Basic Example UNION (aka UNION DISTINCT) UNION ALL Duplicates are preserved. Faster because no deduplication is done. Arrange the UNION Query Practical Usage Real-World Example The performance difference between these two variants is dramatic at scale.