By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
ID_RECIPE | Comp_1 | Comp_2 | Comp_3 | Comp_4 | Comp_5 | QTY_1 | QTY_2 | QTY_3 | QTY_4 | QTY_5 |
---|---|---|---|---|---|---|---|---|---|---|
1 | CPA | CPC | null | null | null | 1.00 | 0.50 | null | null | null |
2 | CPA | CPF | CPH | CPJ | CPP | 10.00 | 7.50 | 3.00 | 2.25 | 0.25 |
Warning: Null value is eliminated by an aggregate or other SET operation.