9. Using the Set Operators

Certification Objectives 9.01 Describe the Set Operators 9.02 Use a Set Operator to Combine Multiple Queries into a Single Query 9.03 Control the Order of Rows Returned ✓ Two-Minute Drill Q&A Self Test

Any SQL query can be described mathematically (relational algebra is the term used for this), but the use of set operators is what recalls school mathematics to many programmers. As your math curriculum may not have included set theory, following is a short summary.