By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 4 Duplicates: 0 Warnings: 0
| id | startdate | enddate | period |
|---|---|---|---|
| 1 | 2024-01-01 | 2024-01-10 | 4 |
| 2 | 2024-01-01 | 2024-01-10 | 3 |
| 3 | 2024-01-01 | 2024-01-05 | 7 |
| 4 | 2024-01-10 | 2024-01-01 | 4 |
| id | startdate | enddate | period | onedate |
|---|---|---|---|---|
| 1 | 2024-01-01 | 2024-01-10 | 4 | 2024-01-01 |
| 1 | 2024-01-01 | 2024-01-10 | 4 | 2024-01-05 |
| 1 | 2024-01-01 | 2024-01-10 | 4 | 2024-01-09 |
| 2 | 2024-01-01 | 2024-01-10 | 3 | 2024-01-01 |
| 2 | 2024-01-01 | 2024-01-10 | 3 | 2024-01-04 |
| 2 | 2024-01-01 | 2024-01-10 | 3 | 2024-01-07 |
| 2 | 2024-01-01 | 2024-01-10 | 3 | 2024-01-10 |
| 3 | 2024-01-01 | 2024-01-05 | 7 | 2024-01-01 |