This section contains reference documentation for the percentile function.
Last updated 2 years ago
Was this helpful?
Returns the max - min value in a group
max
min
percentile(colName, percentile)
These examples are based on the .
select percentile(homeRuns, 50) AS value from baseballStats
0
select percentile(homeRuns, 80) AS value from baseballStats
4
select percentile(homeRuns, 99.9) AS value from baseballStats
46