count_if
aggregate function
Applies to: Databricks SQL Databricks Runtime
Returns the number of true values for the group in expr
.
Syntax
count_if ( [ALL | DISTINCT] expr ) [ FILTER ( WHERE cond ) ]
This function can also be invoked as a window function using the OVER
clause.
Arguments
expr
: A BOOLEAN expression.cond
: An optional boolean expression filtering the rows used for aggregation.