By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| period | CODE | VLR1 | VLR2 | Desired_Column |
|---|---|---|---|---|
| 2019-01 | 101 | 1000 | 100 | 5900 |
| 2019-01 | 101 | 2000 | 100 | 5900 |
| 2019-01 | 103 | 3000 | 100 | 5900 |
| 2019-01 | 722 | 0 | 0 | 0 |
4 rows affected
| period | CODE | VLR1 | VLR2 | Desired_Column |
|---|---|---|---|---|
| 2019-01 | 101 | 1000 | 100 | 5900 |
| 2019-01 | 101 | 2000 | 100 | 5900 |
| 2019-01 | 103 | 3000 | 100 | 5900 |
| 2019-01 | 722 | 0 | 0 | 0 |