Aggregates Aggregate

sum()

Calculates the sum value for all tuples in arg.

Arguments & returns

8 overloads

`sum(arg)`

Aggregate

Overload link	`arg`	Returns
#01	`BIGINT`	`HUGEINT`
#02	`BIGNUM`	`BIGNUM`
#03	`BOOLEAN`	`HUGEINT`
#04	`DECIMAL`	`DECIMAL`
#05	`DOUBLE`	`DOUBLE`
#06	`HUGEINT`	`HUGEINT`
#07	`INTEGER`	`HUGEINT`
#08	`SMALLINT`	`HUGEINT`

Example

SELECT sum(A)
FROM (VALUES
  (10),
  (20),
  (NULL)
) AS sample("A");

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example with sample data · Run to view results.

In a query

Give your timestamps a rhythm.

Group events into calendar months with date_trunc. The same pattern works for days, weeks, and years.

SELECT
  date_trunc('month', sold_at) AS month,
  sum(amount) AS revenue
FROM (VALUES
  (DATE '2026-06-03', 120),
  (DATE '2026-06-18', 85),
  (DATE '2026-07-02', 150)
) AS sales(sold_at, amount)
GROUP BY 1 ORDER BY 1;

Haybarn WASM 1.5.5-rc3 · In your browser

Guide recipe · Run to view results.

In other engines

BigQuery`sum()`

SELECT SUM(x IGNORE NULLS) AS x

In DuckDB

SELECT SUM(x) AS x

SQLGlot example ↗

Used in larger rewrites 1

These examples use sum as one part of a larger SQL translation.

Snowflake

SELECT * FROM produce PIVOT(SUM(produce.sales) FOR produce.quarter IN ('Q1', 'Q2'))