By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
qty | product_id | Type | carton_no |
---|---|---|---|
18 | 111 | single | 1 |
18 | 111 | single | 2 |
18 | 111 | single | 3 |
48 | 115 | single | 4 |
48 | 115 | single | 5 |
48 | 115 | single | 6 |
36 | 119 | single | 7 |
36 | 119 | single | 8 |
18 | 111 | single | 9 |
36 | 119 | single | 10 |
16 | 199 | single | 11 |
16 | 199 | single | 12 |
4 | 111 | mix | 13 |
4 | 115 | mix | 13 |
4 | 119 | mix | 13 |
4 | 199 | mix | 13 |
Numbering | QTY | product_id | Type |
---|---|---|---|
1-3 | 54 | 111 | single |
4-6 | 144 | 115 | single |
7-8 | 72 | 119 | single |
9 | 18 | 111 | single |
10 | 36 | 119 | single |
11-12 | 32 | 199 | single |
13 | 4 | 111 | mix |
13 | 4 | 115 | mix |
13 | 4 | 119 | mix |
13 | 4 | 199 | mix |