Aggregates Aggregate

approx_top_k()

Finds the k approximately most occurring values in the data set

Arguments & returns

Aggregate

Overload link	`val`	`k`	Returns
#01	`ANY`	`BIGINT`	`ANY[]`

SELECT approx_top_k(x, 5)
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.