---
cuppy_hub: salesforce
cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/percentile-disc.md
cuppy_section: docs
cuppy_doc: X3ZB-JB2X
cuppy_doc_uuid: 84a1ed05-bd0d-4d3f-9d46-ef6e1458b43e
cuppy_permalink: https://cuppy.io/salesforce/d/X3ZB-JB2X
cuppy_version: 1
cuppy_updated: 2026-10-23T16:16:52.575Z
cuppy_canonical: https://cuppy.io/salesforce/docs/reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/percentile-disc
cuppy_mcp: https://cuppy.io/mcp
cuppy_body_sha256: 1e614fcc1361c8e74fc445e916dcc4c600e6163c025c409911805a9c74baab37
# cuppy_body_sha256 is over the document body ALONE, excluding both generated blocks.
---

> Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/percentile-disc.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.

## `PERCENTILE_DISC`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Computes a discrete percentile, returning the first input value whose position in the ordering equals or exceeds the specified fraction.

*   `<fraction>`: A `double precision` value between 0 and 1 specifying the percentile to compute.
*   `<sort_expression>`: An expression of any sortable type.

Returns the same type as the sort expression. Returns NULL if the fraction is NULL.

*   This is an ordered-set aggregate function.
*   NULL values in the sorted input are ignored.
*   Returns an actual value from the input set (no interpolation).
*   Use `PERCENTILE_CONT` for continuous percentiles with interpolation.

Find the median (50th percentile).

Find the 25th and 75th percentiles.

Calculate percentiles for each group.

*   [PERCENTILE_CONT](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/percentile-cont.html)
*   [MODE](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/mode.html)
*   [Aggregate Functions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/aggregate.html)


---
<!-- cuppy -->
You are reading one file. The same content is free over MCP at https://cuppy.io/mcp with no signup: ranked search across all 376 documents in this hub, the merged view when you work in a layer, known workarounds matched to the error you hit, and depth control so you spend tokens on what you need. Start with the `_hello` tool. How to connect: https://cuppy.io/salesforce/ Something wrong in this document? Report it with the `session feedback` tool on the same endpoint.
<!-- /cuppy -->