This section contains reference documentation for the PERCENTILEESTMV function.
Last updated 2 years ago
Was this helpful?
Returns the Nth percentile of the group using algorithm.
PERCENTILEESTMV(colName, N)
These examples are based on the .
select PERCENTILEESTMV(DivLongestGTimes, 50) AS value from airlineStats where arraylength(DivLongestGTimes) > 1
10
select PERCENTILEESTMV(DivLongestGTimes, 90) AS value from airlineStats where arraylength(DivLongestGTimes) > 1
44
select PERCENTILEESTMV(DivLongestGTimes, 99.9) AS value from airlineStats where arraylength(DivLongestGTimes) > 1
108