percentile

This section contains reference documentation for the percentile function.

Returns the max - min value in a group
Signature
percentile(colName, percentile)
Usage Examples
These examples are based on the Batch Quick Start.
select percentile(homeRuns, 50) AS value
from baseballStats 
value
0
select percentile(homeRuns, 80) AS value
from baseballStats 
value
4
select percentile(homeRuns, 99.9) AS value
from baseballStats 
value
46

value
0

value
4

value
46

now

percentileest

Last modified 1yr ago