MINUS

Removes the members of one or more result sets from a another result set.

Syntax

set1 «MINUS set2»

Parameters

set1

A result set that resulted from the execution of a set-producing command. The sets must all have the same component structure.

set2

A result set that resulted from the execution of a set-producing command. The sets must all have the same component structure.

Comments

When used within a FIND command, the result set contains all members of set1 that are not also in set2, and so on.

 

Related Topics