Table of Contents

Miscellaneous

Difference between UNION and UNION ALL

Unions are used to join tables on column level, usually when we need to join two sets from the same table into one result. But what is difference in UNION and UNION ALL?

UNION ALL

UNION