PARTITION BY

An OVER subclause dividing query rows into independent window-function groups.

What is PARTITION BY in a relational database?

PARTITION BY — An OVER subclause dividing query rows into independent window-function groups.

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