By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
| ID | COL1 | COL2 | COL3 |
|---|---|---|---|
| 2 | 12345 | null | A |
| 1 | 12345 | 100 | A |
| 7 | 12346 | 20 | B |
| 6 | 12346 | 100 | B |
7 rows affected
| ID | COL1 | COL2 | COL3 |
|---|---|---|---|
| 2 | 12345 | null | A |
| 1 | 12345 | 100 | A |
| 7 | 12346 | 20 | B |
| 6 | 12346 | 100 | B |