FunctionsWindow

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.

lag_in_frame(…) → Dynamic

Kind · window

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.

Part of the Window family.

lag

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

last_value

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