Skip to content

BOOLAND_AGG

BOOLAND_AGG

Compute the logical AND of the boolean value of every input in a column/group/window, returning NULL if there are no non-NULL entries, otherwise returning True if all non-NULL entries are also non-zero. This is supported for numeric and boolean types.