By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
ID | START_DATE | END_DATE | SNOS |
---|---|---|---|
1 | 2020-10-11 00:00:00 | 2020-10-11 00:00:00 | 1 |
1 | 2020-11-04 00:00:00 | 2020-12-20 00:00:00 | 2,3,4,5 |
1 | 2021-01-01 00:00:00 | 2021-03-25 00:00:00 | 6,7 |
ID | START_DATE | END_DATE | SNOS |
---|---|---|---|
1 | 2020-10-11 00:00:00 | 2020-10-11 00:00:00 | 1 |
1 | 2020-11-04 00:00:00 | 2020-12-20 00:00:00 | 2,3,4,5 |
1 | 2021-01-01 00:00:00 | 2021-03-25 00:00:00 | 6,7 |