By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
9 rows affected
Days | Status | Seq | rn |
---|---|---|---|
2022-01-01 | on | 2022-01-01 | 1 |
2022-01-02 | on | 2022-01-02 | 2 |
2022-01-03 | on | 2022-01-03 | 3 |
2022-01-05 | on | 2022-01-05 | 4 |
2022-01-07 | on | 2022-01-07 | 5 |
2022-01-08 | on | 2022-01-08 | 6 |
Days | Status | Seq | diff |
---|---|---|---|
2022-01-01 | on | 2022-01-01 | -1 |
2022-01-02 | on | 2022-01-02 | -1 |
2022-01-03 | on | 2022-01-03 | -1 |
2022-01-05 | on | 2022-01-05 | 0 |
2022-01-07 | on | 2022-01-07 | 1 |
2022-01-08 | on | 2022-01-08 | 1 |
ON_DATE | OF_DATE | COUNT_OF_ACTIVE_DAYS |
---|---|---|
2022-01-01 | 2022-01-04 | 3 |
2022-01-05 | 2022-01-06 | 1 |
2022-01-07 | 2022-01-09 | 2 |