add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ID CustomerID SomeDate
1 1000 2022-06-10
2 1000 2022-06-17
3 1000 2022-06-22
4 1000 2022-06-26
5 1000 2022-07-01
6 1000 2022-07-07
7 1000 2022-07-17
ID CustomerID StartDate EndDate SomeValue
A 1000 2022-06-01 2022-06-15 225
B 1000 2022-06-16 2022-06-20 400
C 1000 2022-06-21 2022-06-29 350
D 1000 2022-07-02 2022-07-09 500
ID CustomerID SomeDate SomeValue
1 1000 2022-06-10 225
2 1000 2022-06-17 400
3 1000 2022-06-22 350
4 1000 2022-06-26 350
5 1000 2022-07-01 0
6 1000 2022-07-07 500
7 1000 2022-07-17 0