COUNT_IF
Counts the number of TRUE
input values.
This function is equivalent to COUNT
(
CASE
WHEN X THEN 1 END)
.
Syntax
Arguments
X
X
Type: any
Values that be evaluated as a Boolean
.
Returns
Type: bigint
Returns the number of TRUE
input values.
Examples
Transformation job example
SQL
Query result
Last updated