Aggregates Aggregate

mad()

Returns the median absolute deviation for the values within x. NULL values are ignored. Temporal types return a positive INTERVAL.

Arguments & returns

8 overloads

Aggregate

SELECT mad(x)
FROM (VALUES
  (DATE '2026-06-01'),
  (DATE '2026-07-01'),
  (NULL)
) AS sample("x");

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example with sample data · Run to view results.