What is the difference between UNION and UNION ALL |
Question :- What is the difference between UNION and UNION ALL?
Main difference between UNION and UNION ALL is that UNION removes duplicate records, but UNION ALL does not remove duplicate records.
UNION of Table_A and Table_B = 10, 20, 15 while UNION ALL of Table_A and Table_B = 10, 20, 15, 20
Performance of UNION ALL is considered better than UNION, since UNION ALL does not require additional work of removing duplicates.
If you want to be better in Analytics, then do follow the below Playlist:-
Excel Playlist:- • What is MS Excel | Introduction To Excel |...
SQL Playlist:- • Introduction to SQL | SQL For Beginners | ...
Google Data Studio playlist:- • Introduction to Looker|Introduction to Goo...
You can follow us on the below social media handles:-
Blog: - https://thedatamillennials.blogspot.com/
Facebook:- / the-data-millennials-596575371027542
Instagram: - / the_data_millennials
LinkedIn: - / data-millennials-6b5a031b3
Twitter: - / datamillennials