---
title: "lead window function in Strata | Oplema"
description: "Get a value from a later row in a window, so each row can be compared with what follows it. Use it in a Strata Formula with an OVER clause."
url: "https://oplema.com/docs/strata/functions/lead"
updated: "2026-11-04"
---

# lead

Compare each row with a value from a later row.

## Try an expression

In [Formula](https://oplema.com/docs/strata/prep/formula), enter the expression and set Output type to **INTEGER**.

Example input

1. Row 1 `id = 1, amount = 10`
2. Row 2 `id = 2, amount = NULL`
3. Row 3 `id = 3, amount = 30`
4. Row 4 `id = 4, amount = 30`

### Expression

```
lead(amount) OVER (ORDER BY id)
```

### Result

```
Row 1: NULL
Row 2: 30
Row 3: 30
Row 4: NULL
```

NULL means the value is missing.

Try it live in Formula

Result
| id | amount | result |
| --- | --- | --- |
| 1 | 10 |  |
| 2 |  | 30 |
| 3 | 30 | 30 |
| 4 | 30 |  |

## Arguments and types

```
lead(expr[, offset[, default]][ ORDER BY ordering][ IGNORE NULLS])
```

The result type can depend on the input types. See DuckDB for the full argument rules.

## Things to know

ORDER BY defines the order used by the calculation; it doesn't sort the output table. Include a unique tie-breaker when row position matters. Window expressions belong in Formula and can't be entered directly in Filter.

Missing values occupy positions by default. The last row has no following value, so this example returns NULL there.

## Related functions

[lag

Compare each row with a value from an earlier row.

](https://oplema.com/docs/strata/functions/lag)[cume\_dist

Find the fraction of rows whose sort value is less than or equal to the current value.

](https://oplema.com/docs/strata/functions/cume-dist)[first\_value

Repeat the first value in a window frame.

](https://oplema.com/docs/strata/functions/first-value)[last\_value

Repeat the last value in a window frame.

](https://oplema.com/docs/strata/functions/last-value)

[Browse across rows](https://oplema.com/docs/strata/functions#across-rows) [DuckDB documentation](https://duckdb.org/docs/current/sql/functions/window_functions.html#leadexpr-offset-default-order-by-ordering-ignore-nulls)

Function metadata from DuckDB, used under the [MIT license](https://github.com/duckdb/duckdb/blob/v1.5.4/LICENSE).
