UNION removes any existing duplicates? | Sololearn: Learn to code for FREE!
Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок
0

UNION removes any existing duplicates?

15th Feb 2016, 4:00 AM
Manish maharjan
Manish maharjan - avatar
1 ответ
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