SUM

SUM

Compute the sum of the column/group/window. Supported on numeric types.

Returns NULL if the input is all NULL or empty.

Note

When used as a window function with an ORDER BY clause but no window frame, ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW is used by default.