Geotab interview question
What is the difference between UNION and UNION ALL?
Interview Answer
Anonymous
1 Feb 2022
Union All extracts all the rows including the duplicates (repeated values) from both the queries whereas UNION eradicates duplicates.
1