percentile
This section contains reference documentation for the percentile function.
Returns the
max
- min
value in a grouppercentile(colName, percentile)
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 |
Last modified 1yr ago