Performing Set Operations

Table 116 lists the set functions that operate on input sets without deriving further information from a database:

Table 116. List of Pure Set Functions

  

Pure Set Function

Description

CrossJoin

Returns a cross-section of two sets from different dimensions.

Distinct

Deletes duplicate tuples from a set.

Except

Returns a subset containing the differences between two sets.

Generate

An iterative function. For each tuple in set1, returns set2.

Head

Returns the first n members or tuples present in a set.

Intersect

Returns the intersection of two input sets.

Subset

Returns a subset from a set, in which the subset is a numerically specified range of tuples.

Tail

Returns the last n members or tuples present in a set.

Union

Returns the union of two input sets.