EVERY

​

Syntax

​

Aggregate

every([DISTINCT] condition)

​

Window over all rows in each group

every(condition) OVER ([PARTITION BY key] ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)

• Use the full-group window shown above. Other frame boundaries, ordering options, and NULL-handling clauses are outside the forms covered on this page.

​

Arguments

​

Aggregate and full-group window

​

Returns

• Type: BOOLEAN
• Possible values: TRUE, FALSE or NULL.
• NULL behavior: NULL inputs are ignored. All-NULL groups return NULL.
• Empty input: An empty global aggregate returns NULL.

​

Properties

​

Usage notes

• Grouped EVERY returns the minimum BOOLEAN value: FALSE takes precedence over TRUE.
• Deterministic: Boolean MIN/MAX is independent of input order.
• Supports DISTINCT: Duplicate Boolean inputs cannot change the aggregate result.

​

Examples

​

Combine Boolean inputs

WITH t(condition) AS (VALUES (TRUE),(TRUE),(CAST(NULL AS BOOLEAN))) SELECT every(condition) AS result FROM t;

​

All NULL inputs

WITH t(condition) AS (VALUES (CAST(NULL AS BOOLEAN))) SELECT every(condition) AS result FROM t;

​

Limitations

• Use the grouped aggregate or the full-group ROWS window shown here. Other window forms are outside this page’s coverage.