By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
ITEM_NO | ITEM_TYPE | ACTIVE_FROM | ACTIVE_TO |
---|---|---|---|
10001 | SAR | 2020-05-01 00:00:00 | 2021-06-01 00:00:00 |
2 rows affected
ITEM_NO | ITEM_TYPE | ACTIVE_FROM | ACTIVE_TO |
---|---|---|---|
10001 | SPR | 2023-01-31 00:00:00 | 2023-01-31 00:00:00 |