By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| NAME | MISSING |
|---|---|
| A | 06-JAN-00 |
| A | 07-JAN-00 |
| A | 09-JAN-00 |
| B | 06-FEB-01 |
| B | 07-FEB-01 |
| B | 08-FEB-01 |
8 rows affected
| NAME | MISSING |
|---|---|
| A | 06-JAN-00 |
| A | 07-JAN-00 |
| A | 09-JAN-00 |
| B | 06-FEB-01 |
| B | 07-FEB-01 |
| B | 08-FEB-01 |