By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
| sortorder | productid | toolgroup | qty | bucket |
|---|---|---|---|---|
| 2 | PRD2 | A2 | 125 | 0 |
| 3 | PRD3 | A2 | 12 | 0 |
| 4 | PRD4 | A2 | 135 | 0 |
| 5 | PRD5 | A3 | 125 | 0 |
| 6 | PRD6 | A3 | 44 | 0 |
| 6 | PRD6 | A3 | 440 | 1 |
| 1 | PRD1 | A1 | 405 | 2 |
| 6 | PRD6 | A3 | 36 | 2 |
| 1 | PRD1 | A1 | 440 | 3 |
| 1 | PRD1 | A1 | 55 | 4 |
| 7 | PRD7 | A4 | 385 | 4 |