Understanding Set Operations
Overview
A set operation contains
-
two queries (each beginning with a SELECT clause)
-
a set operator
-
one or both of the keywords ALL and CORR (CORRESPONDING).
|
General form of an SQL
query using a set operator:
SELECT column-1<,
... column-n>
FROM table-1
| view-1<,
... table-n | view-n>
<optional
query clauses>
set-operator <ALL> <CORR>
SELECT column-1<,
... column-n>
FROM table-1
| view-1<,
... table-n | view-n>
<optional
query clauses>;
SELECT
specifies the column(s)
that will appear in the result.
FROM
specifies the table(s)
or view(s) to be queried.
optional query clauses
are used to refine the query further and include the clauses ... |
Get SAS Certification Prep Guide, 4th Edition 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.
