Chapter 25. Relational division
Peter Larsson
Relational division is one of the hardest-to-understand areas in relational theory because of the complexity involved. Yet relational division is one of the areas that can be most useful when programming for relational databases.
Why use relational division?
There are many situations where relational division is a good solution. A simple way to think about relational division’s usefulness is to consider situations where you need data from one set that matches ALL the values in another set. For example, you may want to find all customers who have been served by both James and Gabrielle. Or you may want to find all applicants who have experience with Reporting Services, SharePoint, and Integration ...
Get SQL Server MVP Deep Dives, Volume 2 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
