BOOL_OR

Learn how to use the BOOL_OR aggregate function in PlaidCloud Lakehouse. Returns TRUE if any value in the group is TRUE - see syntax, examples, and output.

Returns TRUE if any value in the group is TRUE.

Analyze Syntax

func.bool_or(get_column(table, 'is_active'))

Analyze Examples

func.bool_or(get_column(table, 'is_active'))

SQL Syntax

BOOL_OR(<is_active>)

SQL Examples

SELECT department, BOOL_OR(is_active) FROM employees GROUP BY department;

┌────────────┬─────────────────────┐
│ department │ bool_or(is_active)  │
├────────────┼─────────────────────┤
│ Sales      │                   1 │
│ IT         │                   1 │
└────────────┴─────────────────────┘