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 
select percentile(homeRuns, 80) AS value
from baseballStats 
select percentile(homeRuns, 99.9) AS value
from baseballStats 

Last updated