Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10
Set operations
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
SQL allows to perform set operations as understood in standard set theory on result sets. These operations include unions, intersections, subtractions. For two subselects to be combinable by such a set operator, each subselect must return a table expression of the same degree and type.
All of these set operations come with 2 flavours:
-
DISTINCT(the default): Removing duplicates after applying the set operation -
ALL: Retaining duplicates after applying the set operation
Table of contents
- 3.3.4.17.1.
- Type safety
- 3.3.4.17.2.
- Projection rowtype
- 3.3.4.17.3.
- Differences to standard SQL
- 3.3.4.17.4.
- UNION
- 3.3.4.17.5.
- INTERSECT
- 3.3.4.17.6.
- EXCEPT
| previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!