Powered by GitBook

1 of 1

Loading...

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 .

value

value

value

select percentile(homeRuns, 50) AS value
from baseballStats

0

4

46

Batch Quick Start

select percentile(homeRuns, 80) AS value
from baseballStats

select percentile(homeRuns, 99.9) AS value
from baseballStats