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

With the default window frame (ORDER BY present, no ROWS/RANGE clause), what running total does the highlighted row (v = 10, second tied row) receive?

WITH t(id, v) AS ( VALUES (1, 10), (2, 10), (3, 20) ) SELECT id, v, SUM(v) OVER (ORDER BY v) AS running FROM t ORDER BY id;