percentilemv

This section contains reference documentation for the PERCENTILEMV function.

Returns the Nth percentile of the group where N is a decimal number between 0 and 100 inclusive
Signature
PERCENTILEMV(colName, N)
Usage Examples
These examples are based on the Hybrid Quick Start.
select PERCENTILEMV(DivLongestGTimes, 50) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1
value
10
select PERCENTILEMV(DivLongestGTimes, 90) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1
value
44
select PERCENTILEMV(DivLongestGTimes, 99.9) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1
value
108

value
10

value
44

value
108

percentileestmv

percentiletdigest

Last modified 1yr ago