1 of 1

percentile

This section contains reference documentation for the percentile function.

Returns the max - min value in a group

Signature

percentile(colName, percentile)

These examples are based on the Batch Quick Start.

select percentile(homeRuns, 50) AS value
from baseballStats

value

select percentile(homeRuns, 80) AS value
from baseballStats

value

select percentile(homeRuns, 99.9) AS value
from baseballStats

value

This section contains reference documentation for the percentile function.

Returns the max - min value in a group

percentile(colName, percentile)

These examples are based on the Batch Quick Start.

select percentile(homeRuns, 50) AS value
from baseballStats

value

select percentile(homeRuns, 80) AS value
from baseballStats

value

select percentile(homeRuns, 99.9) AS value
from baseballStats

value