UNION removes any existing duplicates? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

UNION removes any existing duplicates?

15th Feb 2016, 4:00 AM
Manish maharjan
Manish maharjan - avatar
1 Answer
0
Yes. As mentioned in the course... UNION combines multiple datasets into a single dataset, and removes any existing duplicates. UNION ALL combines multiple datasets into one dataset, but does not remove duplicate rows.
20th Feb 2016, 9:06 PM
Gary Chappell