How Can We Help?
< All Topics
Print

MINUS

MINUS

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

Syntax

set1 MINUS set2

Parameters

set1A result set that resulted from the execution of a set-producing command. The sets must all have the same component structure.
set2A 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.

See Also

INTERSECT

Set Specification

UNION

Leave a Reply

Your email address will not be published. Required fields are marked *

en_CAEnglish