# Lead

> Supported in: Batch, Faster

Returns the value of the input expression from the row a set number of rows after the current row in the window, where the number of rows is given by the 'lead' argument (default 1, the immediately following row). Requires an ordered window, since the window's ordering determines which row is after the current row.

**Expression categories:** Aggregate

## Declared arguments

* **Expression:** Expression to lead.<br>*Expression\<T>*
* *optional* **Default value:** Value returned when there are fewer than 'lead' rows after the current row.<br>*Literal\<T>*
* *optional* **Lead:** Number of rows to lead.<br>*Literal\<Integer>*

**Type variable bounds:** *T accepts AnyType*

**Output type:** *T*

## Examples

### Example 1: Base case

**Argument values:**

* **Expression:** `price`
* **Default value:** *null*
* **Lead:** 1

| price | **Output** |
| ----- | ----- |
| 100 | 105 |
| 105 | 98 |
| 98 | 102 |
| 102 | *null* |

***

### Example 2: Null case

**Argument values:**

* **Expression:** `price`
* **Default value:** 0
* **Lead:** 1

| price | **Output** |
| ----- | ----- |
| 100 | 105 |
| 105 | 98 |
| 98 | 102 |
| 102 | 0 |

***