Which of the following is the correct syntax to calculate a running total of sales using a window function?

easy📝 Syntax Q12 of 15

SQL - Advanced Window Functions

ASELECT SUM(sales) OVER (ORDER BY date) AS running_total FROM sales_data;

BSELECT SUM(sales) GROUP BY date ORDER BY running_total FROM sales_data;

CSELECT RUNNING_TOTAL(sales) FROM sales_data ORDER BY date;

DSELECT sales + PREVIOUS(sales) FROM sales_data;

Step-by-Step Solution

Solution:

Step 1: Identify correct window function syntax
SUM() OVER (ORDER BY column) computes running total ordered by that column.
Step 2: Check other options for syntax errors
The other options use invalid SQL syntax or functions that don't exist.
Final Answer:
SELECT SUM(sales) OVER (ORDER BY date) AS running_total FROM sales_data; -> Option A
Quick Check:
SUM() OVER (ORDER BY ...) = running total [OK]

Quick Trick: Use SUM() OVER (ORDER BY ...) for running totals [OK]

Common Mistakes:

Master "Advanced Window Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes