count()

Count the number of rows in each group. If no expression is specified, it returns the total number of rows. If an expression is specified, it returns the number of rows with a non-null value.

Syntax

count
count(EXPR)
Optional Parameters
EXPR
An expression of any type