The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

UNION vs UNION ALL

UNION vs UNION ALL

Super Learner
0
Votes
1
Answer

Hello Team,
Can you please give me an example of when or how we can use this two commands?
To be honest, it was not clear the usage in the video
Thank you!!

#, #
1 Answer

365 Team
0
Votes

Hi Miguel!
Thanks for reaching out and pointing this out.
UNION or UNION ALL add, or, better, unify data from different tables. However, it is important that these tables are of the same length and contain the same column names. Here, the records are combined vertically, so you can think of the first table being vertically extended by the content of the other table(s) you are unifying it with.
The difference between UNION and UNION ALL is that UNION removes duplicate data, while UNION ALL doesn’t.
Practical examples have been provided in the lecture but since you are requesting for more, I will mark your comment and work on this the next time we are updating the course!
Hope this helps.
Best,
Martin

×
LAST CHANCE
Ready to Learn Data Science?
50% OFF