Geotab Interview Question

What is the difference between UNION and UNION ALL?

Interview Answer

Anonymous

Feb 1, 2022

Union All extracts all the rows including the duplicates (repeated values) from both the queries whereas UNION eradicates duplicates.

1