All of

Supported in: Batch, Faster

Calculate the boolean 'and' of an aggregate, using SQL standard semantics for null values.

Expression categories: Aggregate

Declared arguments

• Expression: The column on which to compute 'all'.
  Expression<Boolean>

Output type: Boolean

Examples

Example 1: Base case

Argument values:

• Expression: values

Given input table:

Outputs: false

---

Example 2: Null case

Argument values:

• Expression: values

Given input table:

Outputs: null

---

Example 3: Null case

Argument values:

• Expression: values

Given input table:

Outputs: true

---