Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

SUM Window Function

The SUM window function returns the sum of the input column or expression values. The SUM function works with numeric values and ignores NULL values.


SUM ( [ ALL ] expression ) OVER ( [ PARTITION BY expr_list ] [ ORDER BY order_list frame_clause ] )



The target column or expression that the function operates on.


With the argument ALL, the function retains all duplicate values from the expression. ALL is the default. DISTINCT is not supported.


Specifies the window clauses for the aggregation functions. The OVER clause distinguishes window aggregation functions from normal set aggregation functions.

PARTITION BY expr_list

Defines the window for the SUM function in terms of one or more expressions.

ORDER BY order_list

Sorts the rows within each partition. If no PARTITION BY is specified, ORDER BY uses the entire table.


If an ORDER BY clause is used for an aggregate function, an explicit frame clause is required. The frame clause refines the set of rows in a function's window, including or excluding sets of rows within the ordered result. The frame clause consists of the ROWS keyword and associated specifiers. See Window Function Syntax Summary.

Data Types

The argument types supported by the SUM function are SMALLINT, INTEGER, BIGINT, NUMERIC, DECIMAL, REAL, and DOUBLE PRECISION.

The return types supported by the SUM function are:

  • BIGINT for SMALLINT or INTEGER arguments

  • NUMERIC for BIGINT arguments

  • DOUBLE PRECISION for floating-point arguments


See SUM Window Function Examples.