percentile_disc

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

percentile_cont() follows this syntax.

1SELECT percentile_disc(PERCENTAGE) WITHIN GROUP (ORDER BYFIELD1)
2FROM DATASET;