medium10 pts · first answer countswindow-functionssqlrunning-totals

Filtering before or after the window

You want each day's all-time running revenue total, but only want to show March rows. Where should the March filter go?

A.In the WHERE clause of the same query as the windowB.In the PARTITION BY clause of the window itselfC.In an outer query, after the running total is computedD.In the ORDER BY clause inside the window definition

Discussion 0

Join free to post in the discussion.

Filtering before or after the window

Discussion 0

Related questions