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