An Except clause, or the alternate Minus operator, selects all members of the first subquery that are not also in the second subquery. The results of both subqueries must have identical columns and datatypes.

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

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