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 |