1 of 1

percentiletdigest

This section contains reference documentation for the PERCENTILETDigest function.

Returns the Nth percentile of the group using T-digest algorithm.

Signature

PERCENTILETDigest(colName, percentile)

These examples are based on the Batch Quick Start.

select PERCENTILETDigest(homeRuns, 50) AS value
from baseballStats

value

select PERCENTILETDigest(homeRuns, 80) AS value
from baseballStats

value

select PERCENTILETDigest(homeRuns, 99.9) AS value
from baseballStats

value

This section contains reference documentation for the PERCENTILETDigest function.

Returns the Nth percentile of the group using T-digest algorithm.

PERCENTILETDigest(colName, percentile)

These examples are based on the Batch Quick Start.

select PERCENTILETDigest(homeRuns, 50) AS value
from baseballStats

value

select PERCENTILETDigest(homeRuns, 80) AS value
from baseballStats

value

select PERCENTILETDigest(homeRuns, 99.9) AS value
from baseballStats

value