Dremio Cloud
Dremio Software
 
On this page

    Categories: Percentile

    MEDIAN

    Computes the median of a dataset.

    Syntax

    MEDIAN(order_by_expression numeric) → double precision

    • order_by_expression: The expression to sort and compute the median for.

    Examples

    MEDIAN example 
    SELECT MEDIAN(pop) FROM Samples."samples.dremio.com"."zips.json"
-- EXPR$0
-- 2783.0

    Usage Notes

    This function is used with only numeric data types in Dremio. NULL values in the data set are ignored.

    This function is equivalent to PERCENTILE_CONT(0.5) WITHIN GROUP(ORDER BY order_by_expression).