How do you calculate a running total?

SQL window functions · Freshers and experienced

Model answer

SUM(amount) OVER (ORDER BY order_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW). Specify the frame explicitly, because the default frame with ORDER BY treats rows with equal order values as peers, which can surprise you.

Learn this topic

Window Functions: ROW_NUMBER, RANK and Running Totals in the course SQL for Beginners: Learn Databases Step by Step.

Sign in to add your own answer.

More questions

• What is a window function and how is it different from GROUP BY?
• What is the difference between ROW_NUMBER, RANK and DENSE_RANK?
• What do PARTITION BY and ORDER BY do inside OVER?
• What do LAG and LEAD do?
• How do you find consecutive days (gaps and islands)?
• What does NTILE do and where is it used?