By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
5 rows affected
| emp_code | year1 | year2 | col_code | paidin | YearAmt | Increment | Used | OpeningAmt | ClosingAmt |
|---|---|---|---|---|---|---|---|---|---|
| 330 | 202204 | 202303 | a3 | 202204 | 15000 | 1250 | 100 | null | 16150 |
| 330 | 202204 | 202303 | a3 | 202205 | 15000 | 1250 | 100 | 16150 | 17300 |
| 330 | 202204 | 202303 | a3 | 202206 | 15000 | 1250 | 100 | 17300 | 18450 |
| 330 | 202204 | 202303 | a3 | 202207 | 15000 | 1250 | 100 | 18450 | 19600 |
| 330 | 202204 | 202303 | a3 | 202208 | 15000 | 1250 | 100 | 19600 | 20750 |