Pergunta de entrevista da empresa Geotab
What is the difference between UNION and UNION ALL?
Resposta da entrevista
Sigiloso
1 de fev. de 2022
Union All extracts all the rows including the duplicates (repeated values) from both the queries whereas UNION eradicates duplicates.
1