Signant Health interview question

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

Interview Answer

Anonymous

8 Sept 2022

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