Dears,
I want group by based on sequel of dates.
valid from: 1/1/2019 to valid_to: 12/18/2020 should be one record and it is sequel of dates.
and valid from: 3/1/2021 to valid_to: 3/31/2021 should be another record.
so the result will be two records.
how to partition based on sequel of dates.
Best answer by Tomas Ruderfelt
View original