A query uses SUM(Amount) OVER (PARTITION BY CustomerId ORDER BY OrderDate, OrderId ROWS UNBOUNDED PRECEDING). What does this express?

Published
  1. One total that collapses each customer to a single row
  2. A running sum per customer in the specified deterministic order
  3. A random ordering of orders
  4. The largest single amount across the entire database

Comments — 0