By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| bin | partnumber | sumQty | totQty | rn |
|---|---|---|---|---|
| 1-A | 1-2345 | 150 | 100 | 1 |
| 1-A | 1-2347 | 60 | 10 | 1 |
| 1-A | 1-2348 | 70 | 15 | 1 |
| bin | partnumber | sumQty | totQty | rn |
|---|---|---|---|---|
| 1-A | 1-2345 | 150 | 100 | 1 |
| 1-A | 1-2347 | 60 | 10 | 1 |
| 1-A | 1-2348 | 70 | 15 | 1 |