Why not include duplicates using UNION

screen link: https://app.dataquest.io/m/190/building-and-organizing-complex-queries/5/combining-rows-with-union

When using UNION, why aren’t there duplicates?
OR does UNION drops them automatically?
Could you please explain HOW it works?
Thank you beforehand!

Precisely. Nice catch, we should explain this.

1 Like