By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| COL | LAG(COL)OVER(ORDERBYTO_DATE(COL,'DDD_YYYY')) |
|---|---|
| 52_2019 | null |
| 1_2020 | 52_2019 |
| 2_2020 | 1_2020 |
| COL | MAX(COL)OVER(ORDERBYSEQNUMRANGEBETWEEN1PRECEDINGAND1PRECEDING) |
|---|---|
| 52_2019 | null |
| 1_2020 | 52_2019 |
| 1_2020 | 52_2019 |
| 1_2020 | 52_2019 |
| 2_2020 | 1_2020 |