UNION removes any existing duplicates? | Sololearn: Learn to code for FREE!
Neuer Kurs! Jeder Programmierer sollte generative KI lernen!
Kostenlose Lektion ausprobieren
0

UNION removes any existing duplicates?

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