Conserving Duplicates
(SELECT name
FROM Person
WHERE City=“Seattle”)
UNION ALL
(SELECT name
FROM Person, Purchase
WHERE buyer=name AND store=“The Bon”)
The UNION, INTERSECTION and EXCEPT operators
operate as sets, not bags.
Previous slide
Next slide
Back to first slide
View graphic version