◀ Back to Playground Home

Return the estimated value at the Nth percentile using the quantile digest algorithm

select percentileest(int_field, 50),
       percentileest(long_field, 50),
       percentileest(double_field, 50),
       percentileest(float_field, 50)
FROM users