Window Function

A function calculating across related rows without collapsing them into one row per group.

What is Window Function in a relational database?

Window Function — A function calculating across related rows without collapsing them into one row per group.

SELECT order_id,
       SUM(total_amount) OVER (PARTITION BY customer_id) AS customer_total
FROM purchase_order;

Level: Journeyman · More Database terms at this level

Updated September 27, 2026