SQL Getting Started

Chapter 6. Using Operators and Predicates in Queries

In DB2 Universal Database you can combine queries with different set operators and construct complex conditional statements with quantified predicates.

This chapter explains how to:

• Combine different tables with UNION, EXCEPT and INTERSECT set operators
• Construct complex conditions for queries with quantified predicates. Basic predicates were discussed briefly in Selecting Rows.