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

# max()

Returns the highest row value in a numeric column.

`max()` follows this syntax.

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