Aggregates Aggregate

median()

Returns the middle value of the set. NULL values are ignored. For even value counts, interpolate-able types (numeric, date/time) return the average of the two middle values. Non-interpolate-able types (everything else) return the lower of the two middle values.

Arguments & returns

`median(x)`

Aggregate

Overload link	`x`	Returns
#01	`ANY`	`ANY`

Example

SELECT median(x)
FROM (VALUES
  (10),
  (20),
  (NULL)
) AS sample("x");

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example with sample data · Run to view results.

In a query

Find the middle of the story.

Compare the average with the median to see how an unusually large value changes your summary.

SELECT
  avg(yield_kg) AS average,
  median(yield_kg) AS median
FROM (VALUES (12), (14), (15), (16), (98))
  AS harvest(yield_kg);

Haybarn WASM 1.5.5-rc3 · In your browser

Guide recipe · Run to view results.

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3