How Can We Help?
< All Topics
Print

INTERSECT

INTERSECT

Isolates the common members of two or more result sets.

Syntax

set1 INTERSECT set2

Parameters

set1A result set produced from the execution of a set-producing command. All sets in the command must have the same component structure.
set2A result set produced from the execution of a set-producing command. All sets in the command must have the same component structure.

Comments

When used within a FIND command, the result set contains the members that are common to each of the specified result sets, with duplicates eliminated.

See Also

FIND

MINUS

UNION

2 thoughts on “INTERSECT

  1. When used within a FIND command, the result set contains the members that are common to each of the specified result sets, with duplicates eliminated.

Leave a Reply

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

en_CAEnglish