Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLwindow functions ROW_NUMBER RANKSingle-choice MCQ

When ORDER BY is present but the frame is left as the default, why can two rows with the same ORDER BY key get the same running SUM even though they are different rows?

SUM(x) OVER (ORDER BY d) -- rows with equal d values