medium10 pts · first answer countswindow-functionssqlmoving-average

A date-based 7-day frame

In PostgreSQL 11+, what does this frame include for a row dated 10 June?

SUM(amount) OVER (ORDER BY sale_date
                  RANGE BETWEEN INTERVAL '6 days' PRECEDING AND CURRENT ROW)

A.Exactly 7 rows ending at the current rowB.All rows dated 4 to 10 June, however many there areC.Rows dated 4 to 10 June, but at most one per dateD.Only the rows dated 4 June and 10 June

Discussion 0

Join free to post in the discussion.

A date-based 7-day frame

Discussion 0

Related questions