BOOL_OR() OVER ...
All functions > WINDOW FUNCTION > BOOL_OR() OVER ...
Returns TRUE if any boolean value in the window frame is true.
Syntax
Diagram(
Sequence(
Terminal("BOOL_OR"),
Terminal("("),NonTerminal('expr'),Terminal(")"),
Terminal("OVER"),
Terminal("("),
NonTerminal("over_clause"),
Terminal(")"),
)
)| Parameter | Type | Required | Description |
|---|---|---|---|
expr | EXPRESSION | Yes | Boolean expression to evaluate |
over_clause | OVER CLAUSE | Yes | OVER (PARTITION BY ... ORDER BY ... [FRAME ...]) |
Notes
- Logical OR over all boolean values in the window
- Returns TRUE if any value is true
- NULL values are ignored
- Returns BOOLEAN type