A target table needs existing customer rows updated and new customer rows inserted from one batch. Which operation fits?

Published
  1. SELECT DISTINCT alone
  2. INSERT INTO alone
  3. TRUNCATE TABLE alone
  4. MERGE INTO with matched and unmatched clauses

Comments — 0