By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
owner | hardware_id | grp | from | to |
---|---|---|---|---|
ow1 | 9999 | 1 | 01/02/2019 00:00:00 | 12/06/2019 00:00:00 |
srvc | 9999 | 2 | 12/06/2019 00:00:00 | 17/06/2019 00:00:00 |
ow1 | 9999 | 3 | 17/06/2019 00:00:00 | null |
Warning: Null value is eliminated by an aggregate or other SET operation.