countif

countif — aggregate function to return the count of rows that match the query's predicate.

SYNOPSIS

countif(bool predicate)

countif(T column, bool predicate)

DESCRIPTION

The countif() function with one argument returns the number of rows for which the specified predicate argument evaluates to true. When used with two arguments, it returns the number of rows for which the specified column is not null and the predicate evaluates to true.

SEE ALSO

This LiveView aggregate function is based on the countif aggregate function in the StreamBase expression language.