MINUS ALL (table operator)

1. Supports the standard SQL syntax: except all

The table operator minus all returns the rows of the first result except those that are also in the second.

SELECT …
  FROM …
MINUS ALL
SELECT …
  FROM …

As with all table operators both sides of minus must have the same number of columns and their types must be compatible based on their position. All null values are considered being the same (not distinct) for this operation.

Each occurrence of a row-value in the second result will remove of appearance of this row-value from the first result.

Related

• Same functionality in standard SQL: except all

• Other table operators:

  • except distinct

  • Union: union [distinct], union all

  • Intersect: intersect [distinct], intersect all

Normative References

The table operation minus all is not covered by any international standard.