Skip to main content
How Can We Help?
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