Powered by GitBook

1 of 1

Loading...

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 .

value

value

value

select PERCENTILETDigest(homeRuns, 50) AS value
from baseballStats

0

3.6571905392487856

46.26787306220119

Batch Quick Start

select PERCENTILETDigest(homeRuns, 80) AS value
from baseballStats

select PERCENTILETDigest(homeRuns, 99.9) AS value
from baseballStats