An Intersect clause finds rows that exist in the results of both subqueries. The results of both subqueries must have identical columns and datatypes.

The following example finds congress persons from Alaska and California that are also female:

Intersect also removes duplicate rows by default, but you can use the ALL keyword to keep duplicate rows if desired.