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).
QUANTILE ( table.column, quantile )
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.
[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. | |||||||||||||
| |||||||||||||
|