Aggregates Aggregate

countif()

Counts the total number of TRUE values for a boolean column

Arguments & returns

Aggregate

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

SELECT countif(quantity > 10) AS large_orders
FROM (VALUES (8), (12), (20)) AS data(quantity);

Haybarn WASM 1.5.5-rc3 · In your browser

Guide example · Run to view results.

SELECT
  countif (A);