COUNT

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Counts the number of input rows or non-null values.

  • *: Counts all rows, including rows with NULL values.
  • <expression>: Counts rows where the expression is not NULL.
  • DISTINCT: Counts only distinct non-null values.

Returns a bigint representing the count.

  • Unlike other aggregates, count returns 0 (not NULL) for empty sets.

Count the total number of rows.

Count the rows with non-null values.

Count the unique values.

Count the rows per group.