---
schema_version: "1"
id: d1ee59cc72bfe6df8439ab07ddbc2a9ec374ef18624f353c744834c57a23d4ca
title: sum()
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_sql/guides/bi-sql-aggregate-sum.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-sum.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: faf4bc29ae513e18fd7aeccbe84cc34560075f67042d6318d6835bdaf34e6b84
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# sum()

Returns the sum of all rows values in a numeric column.

`sum()` follows this syntax.

```nolang
SELECT sum(COLUMN_NAME)
FROM DATASET
WHERE CONDITION;
```