Usage Notes - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantage™ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K
This syntax … Counts the total number of rows …
COUNT(value_expression) in the group for which value_expression is not null.
COUNT (DISTINCT value_expression) in the group for which value_expression is unique and not null.
COUNT(*) in the group of rows on which COUNT operates.

COUNT is valid for any data type.