description |
---|
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 |
---|
0 |
select PERCENTILETDigest(homeRuns, 80) AS value
from baseballStats
value |
---|
3.6571905392487856 |
select PERCENTILETDigest(homeRuns, 99.9) AS value
from baseballStats
value |
---|
46.26787306220119 |