Skip to content
RED SAGSkills
hard20 pts · first answer countswindow-functionssqlmoving-average

PRECEDING with a descending order

What does this frame cover for the row dated 10 March, assuming one row per day?

SUM(sales) OVER (ORDER BY sale_date DESC
                 ROWS BETWEEN 2 PRECEDING AND CURRENT ROW)
Choose one answer

Discussion 0

Join free to post in the discussion.

Related questions