By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| sku | old_price | new_price | change_date |
|---|---|---|---|
| A | 10 | 11 | 2022-01-03 |
| B | 1 | 5.99 | 2022-01-02 |
| B | 5.99 | 3.5 | 2022-01-03 |
| B | 3.5 | 12 | 2022-01-04 |
6 rows affected
| sku | old_price | new_price | change_date |
|---|---|---|---|
| A | 10 | 11 | 2022-01-03 |
| B | 1 | 5.99 | 2022-01-02 |
| B | 5.99 | 3.5 | 2022-01-03 |
| B | 3.5 | 12 | 2022-01-04 |