This website uses cookies to ensure you get the best experience.
Learn more.
A query uses SUM(Amount) OVER (PARTITION BY CustomerId ORDER BY OrderDate, OrderId ROWS UNBOUNDED PRECEDING). What does this express?
Published
- One total that collapses each customer to a single row
- A running sum per customer in the specified deterministic order
- A random ordering of orders
- The largest single amount across the entire database
Comments — 0
Sign in to comment