By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
5 rows affected
| current_name | DATE | ID | NAME | VALUE |
|---|---|---|---|---|
| ROBERT | 30/04/2019 00:00:00 | 101 | JEFFREY | abc |
| ROBERT | 31/05/2019 00:00:00 | 101 | FRANK | bcd |
| ROBERT | 30/06/2019 00:00:00 | 101 | ROBERT | cde |
| JILL | 31/05/2019 00:00:00 | 102 | SAM | bcd |
| JILL | 30/06/2019 00:00:00 | 102 | JILL | cde |