Aggregates Aggregate

count()

Returns the number of non-NULL values in arg.

Arguments & returns

2 overloads

`count()`

Aggregate

Overload link	Returns
#01	`BIGINT`

`count(arg)`

Aggregate

Overload link	`arg`	Returns
#02	`ANY`	`BIGINT`

Example

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

In other engines

Apache Spark`count()`

WITH tbl AS (SELECT 1 AS id, 'eggy' AS name UNION ALL SELECT NULL AS id, 'jake' AS name) SELECT COUNT(DISTINCT id, name) AS cnt FROM tbl

In Haybarn

WITH tbl AS (SELECT 1 AS id, 'eggy' AS name UNION ALL SELECT NULL AS id, 'jake' AS name) SELECT COUNT(DISTINCT CASE WHEN id IS NULL THEN NULL WHEN name IS NULL THEN NULL ELSE (id, name) END) AS cnt FROM tbl

SQLGlot example ↗

SQL Server`count()`

Same function

Used in larger rewrites 1

These examples use count as one part of a larger SQL translation.

Snowflake`approximate_similarity()`

APPROXIMATE_SIMILARITY(sig_col)