By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
| date | id | salary |
|---|---|---|
| 2020-04-30 00:00:00 | 1001 | 3000 |
| 2020-04-30 00:00:00 | 1001 | 4000 |
| 2020-05-31 00:00:00 | 1001 | 4000 |
| 2020-06-30 00:00:00 | 1001 | 4000 |
| 2020-07-31 00:00:00 | 1001 | 4000 |
| 2020-08-31 00:00:00 | 1001 | 4000 |
| 2020-08-31 00:00:00 | 1001 | 5000 |
| 2020-09-30 00:00:00 | 1001 | 5000 |
| 2020-10-31 00:00:00 | 1001 | 5000 |
| 2020-11-30 00:00:00 | 1001 | 5000 |
| 2020-12-31 00:00:00 | 1001 | 5000 |
| 2021-01-31 00:00:00 | 1001 | 5000 |
| 2021-02-28 00:00:00 | 1001 | 5000 |