> ## Documentation Index
> Fetch the complete documentation index at: https://docs.e6data.com/llms.txt
> Use this file to discover all available pages before exploring further.

# EVERY

> Returns TRUE when every non-NULL Boolean input is TRUE; returns FALSE if any contributing input is FALSE.

<div className="e6-meta"><span className="e6-eyebrow e6-eyebrow--quiet">Aggregate · Window</span></div>

NULL inputs are ignored. All-NULL groups return NULL.

## Syntax

A window function keeps each input row and adds a result for that row. `PARTITION BY` groups rows with matching values; without it, all input rows form one group. A frame from `UNBOUNDED PRECEDING` to `UNBOUNDED FOLLOWING` includes every row in the group.

### Aggregate

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
every([DISTINCT] condition)
```

### Window over all rows in each group

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
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

| Name | Type | Required | Description |
| - | - | - | - |
| condition | BOOLEAN | Yes | Boolean inputs to combine. |

## 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

| Property | Value |
| - | - |
| Deterministic | Yes |
| Supports DISTINCT | Partial (Removing duplicate values does not change the result.) |
| Supports window usage | Partial (Use the full-group window shown in Syntax.) |
| Supports window frames | Partial (This page covers a frame from the first through the last row in each group.) |
| Exact result | Yes |

## 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

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
WITH t(condition) AS (VALUES (TRUE),(TRUE),(CAST(NULL AS BOOLEAN))) SELECT every(condition) AS result FROM t;
```

| result |
| - |
| true |

### All NULL inputs

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
WITH t(condition) AS (VALUES (CAST(NULL AS BOOLEAN))) SELECT every(condition) AS result FROM t;
```

| result |
| - |
| NULL |

## Limitations

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


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.