Domanda di colloquio di Signant Health

What is the difference between Union and UnionAll function in SQL.

Risposta di colloquio

Anonimo

8 set 2022

The answer was that Union function combines multiple datasets and removes duplicates and UnionAll combines multiple datasets but doesn't remove duplicates.