Flashcard
Default Frame: RANGE vs ROWS Gotcha
Explains why an ORDER BY window aggregate can silently include peer rows via the default RANGE frame.
Question
With an ORDER BY but no explicit frame, what running-total pitfall arises from the default window frame?
Click to reveal answer