◀ Back to Playground Home

Return the estimated value at the Nth percentile using the T-digest algorithm

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