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