By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
PLANCODECODE | AMOUNT | PCODE | CHILD1_AMOUNT | CHILD2_AMOUNT |
---|---|---|---|---|
CHOICE | 150.05 | P123 | null | 130 |
CHOICE | 250.05 | P123 | null | 130 |
CHOICE | 150.05 | P1234 | null | 130 |
CHOICE | 250.05 | P1234 | null | 130 |