An ingestion query must combine two compatible result sets while retaining duplicate rows for later explicit processing. Which SQL operation fits?

Published
  1. INTERSECT
  2. UNION ALL
  3. UNION as identical duplicate retention
  4. EXCEPT

Comments — 0