Two compatible query results contain duplicate rows that must all be retained when combined. Which operation is appropriate?

Published
  1. UNION
  2. INTERSECT
  3. UNION ALL
  4. An equality filter between every selected column

Comments — 0