lead

Returns a value evaluated at the row that is offset rows after the current row within the ordered frame. This function is similar to leadInFrame, but always uses the ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING frame.

Syntax

For more detail on window function syntax see: Window Functions - Syntax.

Parameters

• x — Column name.
• offset — Offset to apply. (U)Int*. (Optional - 1 by default).
• default — Value to return if calculated row exceeds the boundaries of the window frame. (Optional - default value of column type when omitted).

Returned value

• value evaluated at the row that is offset rows after the current row within the ordered frame.

Example

This example looks at historical data for Nobel Prize winners and uses the lead function to return a list of successive winners in the physics category.