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

In PostgreSQL, what does this query return for the row where salary = 5000, given that three other rows in the same department also have salary = 5000?

SELECT salary, SUM(amount) OVER ( ORDER BY salary RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) AS running FROM payouts;