Chapter 13 – Set Operators Functions

"The man who doesn't read good books has no advantage over the man who can't read them."

- Mark Twain

Rules of Set Operators

1.Each query will have at least two SELECT Statements separated by a SET Operator


3.Must specify the same number of columns from the same domain (data type/range)

4.If using Aggregates, both SELECTs much have their own GROUP BY

5.Both SELECTS must have a FROM Clause

6.The First SELECT is used for all ALIAS and FORMAT Statements

7.The Second SELECT will have the ORDER BY statement which must be a number

8.When multiple operators the order of precedence is INTERSECT, UNION, and MINUS

9.Parentheses can change the order of Precedence ...

Get Tera-Tom Genius Series - DB2 SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.