UNION ALL Preserves Duplicates?!

UNION ALL keeps ALL rows! UNION removes duplicates. This one keyword difference changes the entire result set. This will break your data!

#sql #sqltricks #union #unionall #duplicates #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #setoperations #advancedsql

https://www.youtube.com/watch?v=_Sa8Kgc-nuU