By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 9
| t2id | t2c4 | t2dt |
|---|---|---|
| 1 | AAAA | 2021-06-11 |
| 2 | BBBB | 2022-04-20 |
| 3 | BBBB | 2022-04-30 |
| 4 | CCCC | 2019-11-04 |
| 5 | TRUC | 2022-01-07 |
| 6 | TRUC | 2022-01-15 |
| 7 | TRUC | 2022-02-01 |
| 8 | TRUC | 2022-02-08 |
| 9 | ZZZZ | 2025-08-11 |
SELECT 9
DELETE 2
| t2id | t2c4 | t2dt |
|---|---|---|
| 1 | AAAA | 2021-06-11 |
| 2 | BBBB | 2022-04-20 |
| 3 | BBBB | 2022-04-30 |
| 4 | CCCC | 2019-11-04 |
| 5 | TRUC | 2022-01-07 |
| 6 | TRUC | 2022-01-15 |
| 9 | ZZZZ | 2025-08-11 |
SELECT 7
CREATE TABLE
INSERT 0 9
| t1id | t1c4 | t1dt |
|---|---|---|
| 1 | AAAA | 2021-06-11 |
| 2 | BBBB | 2022-04-20 |
| 3 | BBBB | 2022-04-30 |
| 4 | CCCC | 2019-11-04 |
| 5 | TRUC | 2022-01-07 |
| 6 | TRUC | 2022-01-15 |
| 7 | TRUC | 2022-02-01 |
| 8 | TRUC | 2022-02-08 |
| 9 | ZZZZ | 2025-08-11 |
SELECT 9
DELETE 2
| t1id | t1c4 | t1dt |
|---|---|---|
| 1 | AAAA | 2021-06-11 |
| 2 | BBBB | 2022-04-20 |
| 3 | BBBB | 2022-04-30 |
| 4 | CCCC | 2019-11-04 |
| 5 | TRUC | 2022-01-07 |
| 6 | TRUC | 2022-01-15 |
| 9 | ZZZZ | 2025-08-11 |
SELECT 7