11. SQL Essentials & Advanced Flashcards
1
Q
UNION
A
Everything but excluding duplicates
2
Q
UNION ALL
A
Everything including duplicates
3
Q
INTERSECT
A
Only the duplicates
UNION
Everything but excluding duplicates
UNION ALL
Everything including duplicates
INTERSECT
Only the duplicates