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)
Usage Examples
These examples are based on the Batch Quick Start.
select PERCENTILETDigest(homeRuns, 50) AS value
from baseballStats 
value
0
select PERCENTILETDigest(homeRuns, 80) AS value
from baseballStats 
value
3.6571905392487856
select PERCENTILETDigest(homeRuns, 99.9) AS value
from baseballStats 
value
46.26787306220119

value
0

value
3.6571905392487856

value
46.26787306220119

percentilemv

percentiletdigestmv

Last modified 1yr ago