First

Supported in: Batch

First item in the group. Note, if used within an aggregate or unordered window, the row selected will be non-deterministic.

Expression categories: Aggregate

Declared arguments

• Expression - Expression to aggregate.
  Expression<T>
• Ignore nulls - If true, null values will be ignored.
  Literal<Boolean>

Type variable bounds: T accepts AnyType

Output type: T

Examples

Example 1: Base case

Argument values:

• Expression: values
• Ignore nulls: false

Given input table:

Outputs: null

---

Example 2: Base case

Argument values:

• Expression: values
• Ignore nulls: true

Given input table:

Outputs: 2

---