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

# count()

Returns the number of rows that match a specified condition in a column.

`count()` follows this syntax.

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