Aggregates Aggregate

approx_count_distinct()

Computes the approximate count of distinct elements using HyperLogLog.

Arguments & returns

Aggregate

Overload link	`any`	Returns
#01	`ANY`	`BIGINT`

SELECT approx_count_distinct(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.

SELECT APPROX_DISTINCT(a) FROM foo

In DuckDB

SELECT APPROX_COUNT_DISTINCT(a) FROM foo