By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | Value | CreateDT | UpdateDT |
|---|---|---|---|
| 1 | A | 2023-01-20 | 2023-01-21 |
| 2 | A | 2023-01-15 | 2023-01-26 |
| 3 | A | 2023-01-01 | 2023-01-02 |
| 4 | B | 2023-03-01 | 2023-03-08 |
| 5 | C | 2023-02-10 | 2023-02-23 |
| 6 | C | 2023-02-20 | 2023-02-21 |
| 7 | C | 2023-02-01 | 2023-02-08 |
| 8 | D | 2023-04-01 | 2023-04-08 |
| Value | CreateDT | UpdateDT |
|---|---|---|
| A | 2023-01-20 | null |
| C | null | 2023-02-23 |
Warning: Null value is eliminated by an aggregate or other SET operation.