aggregate

BOOL_AND()

Returns TRUE if every value in the group is TRUE (logical AND across rows).

Description

BOOL_AND is an aggregate function that returns TRUE only if every row in the group satisfies the condition (a logical AND across rows). It's handy for checks like "did every employee in this department pass their review?"

Syntax

BOOL_AND(expression)

Parameters

Name	Description	Optional
expression	A boolean expression evaluated per row.	No

Return Type

Returns a BOOLEAN. If the group is empty it returns NULL (or TRUE in some engines for an empty AND).

Examples

Loading playground environment...

Pair with HAVING

Use BOOL_AND in a HAVING clause to keep only groups where every row meets a condition: HAVING BOOL_AND(salary > 40000).

Common Mistakes

Confusing with AND in WHERE. BOOL_AND aggregates across rows; a plain AND in WHERE filters a single row.
Empty groups. An empty group may return NULL rather than TRUE, handle it if it matters.
Non-boolean input. The argument must be boolean; wrap comparisons to make it so.

Related functions

BOOL_OR()

aggregate

Returns TRUE if at least one value in the group is TRUE (logical OR across rows).

Cite this resource

SQLSimplified. "BOOL_AND() SQL Function". Available at: https://sqlsimplified.online/reference/bool-and