By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
| Record | Startdate | EndDate | Type | (No column name) |
|---|---|---|---|---|
| 1234 | 2019-01-01 | 2019-04-01 | TypeA | January2019 |
| 1234 | 2019-01-01 | 2019-04-01 | TypeA | February2019 |
| 1234 | 2019-01-01 | 2019-04-01 | TypeA | March2019 |
| 1234 | 2019-01-01 | 2019-04-01 | TypeA | April2019 |
| 5678 | 2019-03-01 | 2019-04-01 | TypeB | March2019 |
| 5678 | 2019-03-01 | 2019-04-01 | TypeB | April2019 |