FunctionsWindow

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.

lead_in_frame(…) → Dynamic

Kind · window

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.

Part of the Window family.

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.

nth_value

Returns the value of an expression from the nth row of the current window frame. If n is out of range, returns NULL.