Skip to content
RED SAGSkills
medium10 pts · first answer countssqlmergeupsert

Table state after a MERGE

target has (id, v): (1, 10), (2, 20), (3, 30). staging has (2, 25), (4, 40), (5, 50). After this MERGE, how many rows does target have and what is SUM(v)?

MERGE INTO target t
USING staging s ON t.id = s.id
WHEN MATCHED THEN UPDATE SET v = s.v
WHEN NOT MATCHED THEN INSERT (id, v) VALUES (s.id, s.v);
Choose one answer