Signant Health Interview Question

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

Interview Answer

Anonymous

Sep 8, 2022

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