Aggregates Aggregate

variance()

Returns the sample variance of all input values.

Arguments & returns

Aggregate

Overload link	`x`	Returns
#01	`DOUBLE`	`DOUBLE`

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

SELECT VAR_SAMP(x)

In DuckDB

SELECT VARIANCE(x)