FunctionsWindow

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.

nth_value(…) → Dynamic

Kind · window

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

Part of the Window family.

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.

percent_rank

Returns the relative rank of the current row as a value between 0 and 1, computed from rank and the partition size.