By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| InkitemNo | CapacityUnit | NewInk | OldInk | ReturnInk | ProdQty | Description | UsedInk |
|---|---|---|---|---|---|---|---|
| 204 | Machine1 | 5 | 2 | 0 | 4000 | Next | 7.00 |
| 223 | machine2 | 4 | 3 | 1 | 8000 | null | null |
| 204 | Machine2 | 0 | 0 | 0 | 5000 | Next | 0.00 |
| 224 | Machine2 | 4 | 0 | 2 | 3000 | Next | 2.00 |