We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!
Possible clauses and additions of queries whose result sets are joined using UNION, INTERSECT, or EXCEPT. The result set of SELECT statements joined using UNION, INTERSECT, or EXCEPT is regarded as having multiple rows.
The following special conditions apply to clauses and additions of the SELECT statements joined using UNION, INTERSECT, or EXCEPT:
The number of SELECT statements that can be joined using UNION, INTERSECT, or EXCEPT is not limited by a fixed value.
Creates the union set of three aggregate expressions on the same DDIC database table in a subquery of a WITH statement. The union set is selected in a common table expression, which makes it possible to use a single WHERE condition for the entire result set in the main query of the WITH statement. If the union set were created in a main query, every single SINGLE statement would have to contain the same WHERE condition or HAVING condition.