Functions/Aggregates/mean

Aggregates Aggregate

mean()

Calculates the average value for all tuples in x.

Alias of avg()

Arguments & returns

11 overloads

`mean(x)`

Aggregate

Overload link	`x`	Returns
#01	`BIGINT`	`DOUBLE`
#02	`DECIMAL`	`DECIMAL`
#03	`DOUBLE`	`DOUBLE`
#04	`HUGEINT`	`DOUBLE`
#05	`INTEGER`	`DOUBLE`
#06	`INTERVAL`	`INTERVAL`
#07	`SMALLINT`	`DOUBLE`
#08	`TIME`	`TIME`
#09	`TIME WITH TIME ZONE`	`TIME WITH TIME ZONE`
#10	`TIMESTAMP`	`TIMESTAMP`
#11	`TIMESTAMP WITH TIME ZONE`	`TIMESTAMP WITH TIME ZONE`

Example

SELECT SUM(x) / COUNT(*)
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.

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3