SQL - Advanced Window Functions
Which of the following is the correct syntax to calculate a running total of
sales ordered by sale_date?Which of the following is the correct syntax to calculate a running total of sales ordered by sale_date?
easy📝 Syntax Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Identify correct use of SUM() OVER()
Running total requires SUM() OVER with ORDER BY clause inside OVER().Step 2: Check each option's syntax
SELECT sales, SUM(sales) OVER (ORDER BY sale_date) FROM sales_table; uses SUM(sales) OVER (ORDER BY sale_date), which is correct syntax for running total.Final Answer:
SELECT sales, SUM(sales) OVER (ORDER BY sale_date) FROM sales_table; -> Option BQuick Check:
SUM() OVER (ORDER BY ...) = running total syntax [OK]
Quick Trick: Use SUM() OVER (ORDER BY column) for running totals [OK]
Common Mistakes:
- Using PARTITION BY instead of ORDER BY for running total
- Omitting OVER() clause
- Placing ORDER BY outside OVER()
Master "Advanced Window Functions" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes