MINUS
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.