Aggregates Aggregate

kahan_sum()

Calculates the sum using a more accurate floating point summation (Kahan Sum).

Arguments & returns

Aggregate

Overload link	`arg`	Returns
#01	`DOUBLE`	`DOUBLE`

SELECT kahan_sum(A)
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.