Question
Which window expression best represents a running total?
Select an option. Your answer will be checked instantly.
Correct Answer: A. SUM(Amount) OVER (ORDER BY Date ROWS UNBOUNDED PRECEDING)
Explanation:
A cumulative frame from the first row through the current row produces a running total.
The ORDER BY defines the sequence in which values accumulate.
Leave a Reply