16.20 - Example: Group Sum - Advanced SQL Engine - Teradata Database

The following query returns the total sum of meat sales for all cities. Note there is no PARTITION BY clause in the SUM function, so all cities are included in the group sum.

   SELECT city, kind, sales,
   SUM(sales) OVER (ROWS BETWEEN UNBOUNDED PRECEDING AND
                    UNBOUNDED FOLLOWING) 
   FROM monthly;

The possible results of the preceding SELECT appear in the table below.