Aggregates Aggregate

histogram_exact()

Returns a LIST of STRUCTs with the fields bucket and count matching the buckets exactly.

Arguments & returns

Aggregate

Overload link	`arg`	`bins`	Returns
#01	`ANY`	`ANY[]`	`MAP`

SELECT histogram_exact(A, [0, 1, 2])
FROM (VALUES
  (10),
  (20),
  (NULL)
) AS sample("A");

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example with sample data · Run to view results.