Aggregates Aggregate

regr_count()

Returns the number of non-NULL number pairs in a group.

Arguments & returns

Aggregate

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

SELECT (SUM(x*y) - SUM(x) * SUM(y) / COUNT(*)) / COUNT(*)
FROM (VALUES
  (10, 10),
  (20, 20),
  (NULL, NULL)
) AS sample("x", "y");

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example with sample data · Run to view results.