PERCENTILE_APPROX_WEIGHT
Returns a weighted approximate percentile value.
Analyze Syntax
func.percentile_approx_weight(get_column(table, 'val'), get_column(table, 'weight'), 0.5)
Analyze Examples
func.percentile_approx_weight(get_column(table, 'val'), get_column(table, 'weight'), 0.5)
┌──────┐
│ 72.5 │
└──────┘
SQL Syntax
PERCENTILE_APPROX_WEIGHT(<val>, <weight>, 0.5)
SQL Examples
SELECT PERCENTILE_APPROX_WEIGHT(val, weight, 0.5) FROM data;
┌──────┐
│ 72.5 │
└──────┘