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

# percentile_disc

Returns the value corresponding to a given percentile. Accepts measure fields as input.

`percentile_cont()` follows this syntax.

```nolang
SELECT percentile_disc(PERCENTAGE) WITHIN GROUP (ORDER BYFIELD1)
FROM DATASET;
```