Problem 1 of 10 · Incremental merge & CDCNext: Pick up the next incremental batch

00:00

Practice / SQL / Incremental merge & CDC

WorkingGuided

EasyAbout 8 minIncremental merge & CDC

Which source keys a MERGE would insert

A MERGE ... WHEN NOT MATCHED THEN INSERT adds source keys the target doesn't have yet. Given source table src and target tgt (each a single column k), return the distinct keys that would be inserted — present in src, absent from tgt. Sort by k.

Columns

src1 column

columntype

kBIGINT

tgt1 column

columntype

kBIGINT

The tables

srcfirst 5 of 6 rows

k

1

1

2

1

2

tgt2 rows

k

1

3

If you get stuck

Show hint · 1 hint Walkthrough Reveal answer

Your query · runs in your browser⌘ Enter to run

Loading editor…

Output · run to see rows