Aggregates Aggregate

count_if()

Counts the total number of TRUE values for a boolean column

Arguments & returns

Aggregate

Overload link	`arg`	Returns
#01	`BOOLEAN`	`HUGEINT`

SELECT count_if(A)
FROM (VALUES
  (TRUE),
  (FALSE),
  (NULL)
) AS sample("A");

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example with sample data · Run to view results.

SELECT COUNTIF(x)

In DuckDB

SELECT COUNT_IF(x)

SELECT COUNT_IF(x > 1) FROM t

In DuckDB

SELECT COUNT_IF((x > 1) IS TRUE) FROM t