By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | reference_number | reference_date | log_date |
|---|---|---|---|
| 1 | 123 | 2024-04-01 | 2024-04-14 |
| 2 | 123 | 2024-04-01 | 2024-04-15 |
| 3 | 123 | 2024-04-01 | 2024-05-01 |
| 4 | 123 | 2024-05-01 | 2024-05-06 |
| id | reference_number | reference_date | log_date | prev_ref_date |
|---|---|---|---|---|
| 4 | 123 | 2024-05-01 | 2024-05-06 | 2024-04-01 |