By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ITEM | MAX(DAY) | MAX(COST)KEEP(DENSE_RANKLASTORDERBYDAY) |
|---|---|---|
| A | 21-AUG-19 | 2 |
| B | 21-AUG-19 | 4 |
| C | 15-AUG-19 | 2 |
| ITEM | MAX(DAY) | MAX(COST)KEEP(DENSE_RANKLASTORDERBYDAY) |
|---|---|---|
| A | 21-AUG-19 | 2 |
| B | 21-AUG-19 | 4 |
| C | 15-AUG-19 | 2 |