Window Frame

The subset of rows around the current row used by a window function.

What is Window Frame in a relational database?

Window Frame — The subset of rows around the current row used by a window function.

SELECT ordered_on,
       SUM(total_amount) OVER (
           ORDER BY ordered_on ROWS BETWEEN 2 PRECEDING AND CURRENT ROW
       ) AS running_total
FROM purchase_order;

Level: Journeyman · More Database terms at this level

Updated September 27, 2026