Name
union — Returns an union of two or more sets
Synopsis
sequence
union
(
|
set1 sequence , |
| set2 sequence ... , | |
setN
sequence); |
Description
The function returns an unordered sequence that consists of all distinct items from all given sets.
All duplicates are removed, including duplicate occurrences of same value in one sequence, thus the function works exactly as
distinct()
when only one parameter is passed.
Parameters
setI
Sequence that contains items of the resulting union.
Return Types
The function returns an unordered sequence of distinct values.