QUANTILE
Description
This function calculates the given quantile value per group. QUANTILE can be applied to INT, FLOAT or DATE columns.
The given quantile has to be an expression that results in a constant float number between 0 (same as MIN) and 1.0 (same as MAX).
Syntax
QUANTILE ( table.column, quantile )
NULL handling
NULL values are ignored, so they do not influence the result. If all the values of a group are NULL, the result for this group is also NULL. The quantile parameter is not allowed to be NULL.
Examples
[1] Get 0 quantile of column. | ||||||||||
| ||||||||||
|
[2] Get 1.0 quantile of column. | ||||||||||
| ||||||||||
|
[3] Get the min quantile by country. | ||||||||||||||||||||||||||
| ||||||||||||||||||||||||||
|
[4] Get the 0.5 quantile mixed with nulls, grouped by country. | ||||||||||||||||||
| ||||||||||||||||||
|
[5] Get the 0.5 quantile using a division as the quantile parameter. | |||||||||||||
| |||||||||||||
|