By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| SaleOrder | TransactionId | Amount | Tax | DeliveryCharge | TotalTax | DeliveryChargeTax | DeliveryChargeTax |
|---|---|---|---|---|---|---|---|
| S1 | T1 | 12.00 | 0.00 | 3.00 | 5.50 | 0 | 0.750000 |
| S1 | T2 | 27.00 | 4.00 | 3.00 | 5.50 | 0 | 0.750000 |
| S2 | T1 | 15.00 | 2.50 | 5.00 | 7.00 | 1 | 1.250000 |
| S2 | T2 | 10.00 | 2.00 | 5.00 | 7.00 | 1 | 1.250000 |