By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| UserCode | ID_1 | Data_1 | ID_2 | Data_2 |
|---|---|---|---|---|
| Bill | 1 | 55 | null | null |
| John | 1 | 34 | 2 | 52 |
| John | 2 | 52 | 3 | 55 |
| Steve | 1 | 34 | 2 | 52 |
| Steve | 2 | 52 | 3 | 55 |
| Steve | 3 | 55 | 4 | 56 |
| UserCode | ID_1 | Data_1 | ID_2 | Data_2 |
|---|---|---|---|---|
| Bill | 1 | 55 | null | null |
| John | 1 | 34 | 2 | 52 |
| John | 2 | 52 | 3 | 55 |
| Steve | 1 | 34 | 2 | 52 |
| Steve | 2 | 52 | 3 | 55 |
| Steve | 3 | 55 | 4 | 56 |