DB
FunctionsWindow

lead

Returns the value of an expression evaluated on a row that is a given number of rows after the current row within the window partition. An optional default is returned when the offset is out of range.

lead(…) → Dynamic

Kind · window

Returns the value of an expression evaluated on a row that is a given number of rows after the current row within the window partition. An optional default is returned when the offset is out of range.

Part of the Window family.

last_value

Returns the value of an expression from the last row of the current window frame.

lead_in_frame

Like lead, but the offset is constrained to the current window frame rather than the whole partition. Returns NULL (or the provided default) when the referenced row is outside the frame.