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 |