---
schema_version: "1"
id: d77d1b9387f9ccabfa4c87c601339b25f70e3089fc1e199279258cd4a6d68b3c
title: avg()
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-avg.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-avg.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: a5e820015bbbff782cc949d046b50064738335cfa6bf95a37919940841ab1921
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# avg()

Takes the average of row values in a given column.

`avg()` follows this syntax.

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