Integrate Software AG Products Using Digital Event Services 10.4 | Integrate Software AG Products Using Digital Event Services | MashZone NextGen Help | Appendix | Legacy Presto components | MashZone NextGen Analytics | RAQL Queries | Joins and Other Multiple-Dataset Operations | Except or Minus: Find All Less the Intersection
 
Except or Minus: Find All Less the Intersection
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.

Copyright © 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release