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 | Intersect: Find Common Dataset Members
 
Intersect: Find Common Dataset Members
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.

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