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.

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

pt_BRPortuguese