DB
FunctionsWindow

last_value

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

last_value(…) → Dynamic

Kind · window

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

Part of the Window family.

lag_in_frame

Like lag, 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.

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.