percentile_hash
Descriptionβ
Constructs DOUBLE values as PERCENTILE values.
Syntaxβ
PERCENTILE_HASH(x);
Parametersβ
x
: The supported data type is DOUBLE.
Return valueβ
Returns a PERCENTILE value.
Examplesβ
mysql> select percentile_approx_raw(percentile_hash(234.234), 0.99);
+-------------------------------------------------------+
| percentile_approx_raw(percentile_hash(234.234), 0.99) |
+-------------------------------------------------------+
| 234.23399353027344 |
+-------------------------------------------------------+
1 row in set (0.00 sec)