Abstract
SQL and set theory are quite related, but in practical daily life, many developers (the author included) do not worry too much about theory. Maybe as a consequence thereof, it is typically more seldom to see the set operators used than joins. But maybe because the set operators aren’t used as much, too often code is seen where the developer unwittingly fell into one of the pitfalls that exists, specifically concerning using distinct sets or sets with duplicates. And when you then add that the set and multiset operators have opposite defaults, confusion can easily abound. This chapter attempts to clear that confusion.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
