By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| ID | ColTest1 | ColTest2 | Code1 | Code2 |
|---|---|---|---|---|
| 1 | 2 | 3 | xx | NULL |
| 1 | 3 | 4 | yy | zzz |
| 2 | 5 | 6 | NULL | ss |
8 rows affected
| ID | ColTest1 | ColTest2 | Code1 | Code2 |
|---|---|---|---|---|
| 1 | 2 | 3 | xx | NULL |
| 1 | 3 | 4 | yy | zzz |
| 2 | 5 | 6 | NULL | ss |