By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| version() |
|---|
| 8.0.30 |
Records: 8 Duplicates: 0 Warnings: 0
| id | dateadded | dateremoved | serialnumber |
|---|---|---|---|
| 1 | 2022-01-01 | null | ABC1 |
| 2 | 2022-01-02 | 2022-01-04 | ABC2 |
| 3 | 2022-01-03 | null | ABC3 |
| 4 | 2022-01-04 | 2022-01-08 | ABC4 |
| 5 | 2022-01-03 | null | DEF1 |
| 6 | 2022-01-04 | 2022-01-04 | DEF2 |
| 7 | 2022-01-05 | null | DEFC3 |
| 8 | 2022-01-06 | 2022-01-08 | DEF4 |
| d | serialnumber |
|---|---|
| 2022-01-01 | ABC1 |
| 2022-01-02 | ABC1 |
| 2022-01-02 | ABC2 |
| 2022-01-03 | ABC1 |
| 2022-01-03 | ABC2 |
| 2022-01-03 | ABC3 |
| 2022-01-03 | DEF1 |
| 2022-01-04 | ABC1 |
| 2022-01-04 | ABC2 |
| 2022-01-04 | ABC3 |
| 2022-01-04 | ABC4 |
| 2022-01-04 | DEF1 |
| 2022-01-04 | DEF2 |
| 2022-01-05 | ABC1 |
| 2022-01-05 | ABC3 |
| 2022-01-05 | ABC4 |
| 2022-01-05 | DEF1 |
| 2022-01-05 | DEFC3 |
| 2022-01-06 | ABC1 |
| 2022-01-06 | ABC3 |
| 2022-01-06 | ABC4 |
| 2022-01-06 | DEF1 |
| 2022-01-06 | DEF4 |
| 2022-01-06 | DEFC3 |
| 2022-01-07 | ABC1 |
| 2022-01-07 | ABC3 |
| 2022-01-07 | ABC4 |
| 2022-01-07 | DEF1 |
| 2022-01-07 | DEF4 |
| 2022-01-07 | DEFC3 |