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.

1percentile_disc(<fraction>) WITHIN GROUP (ORDER BY <sort_expression>)

• <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).

1SELECT percentile_disc(0.5) WITHIN GROUP (ORDER BY salary) AS median_salary
2FROM employees;

Find the 25th and 75th percentiles.

1SELECT
2    percentile_disc(0.25) WITHIN GROUP (ORDER BY score) AS q1,
3    percentile_disc(0.5) WITHIN GROUP (ORDER BY score) AS median,
4    percentile_disc(0.75) WITHIN GROUP (ORDER BY score) AS q3
5FROM test_results;

Calculate percentiles for each group.

1SELECT department,
2    percentile_disc(0.9) WITHIN GROUP (ORDER BY response_time) AS p90_response
3FROM service_calls
4GROUP BY department;

• PERCENTILE_CONT
• MODE
• Aggregate Functions