By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| SALES_KEY | NET_TTL | NET_TTL_TAX | MKT_TAX_AMT | ID |
|---|---|---|---|---|
| 1 | 1.1200 | 2.1200 | 3.1200 | 1 |
| 1 | 1.1200 | 2.1200 | 3.1200 | 2 |
| 2 | 4.1200 | 5.1200 | 6.1200 | 3 |
| 3 | 7.1200 | 8.1200 | 9.1200 | 4 |
| SALES_KEY | NET_TTL | NET_TTL_TAX | MKT_TAX_AMT | ID | RowNum |
|---|---|---|---|---|---|
| 1 | 1.1200 | 2.1200 | 3.1200 | 1 | 1 |
| 1 | 1.1200 | 2.1200 | 3.1200 | 2 | 2 |
| 2 | 4.1200 | 5.1200 | 6.1200 | 3 | 1 |
| 3 | 7.1200 | 8.1200 | 9.1200 | 4 | 1 |
| SALES_KEY | NET_TTL | NET_TTL_TAX | MKT_TAX_AMT | ID |
|---|---|---|---|---|
| 1 | 1.1200 | 2.1200 | 3.1200 | 1 |
| 1 | 0.0000 | 0.0000 | 0.0000 | 2 |
| 2 | 4.1200 | 5.1200 | 6.1200 | 3 |
| 3 | 7.1200 | 8.1200 | 9.1200 | 4 |