leadInFrame, but always reads the whole partition; a window frame, if specified, is ignored.
Syntax
x— Column name.offset— Offset to apply. (U)Int*. (Optional -1by default).default— Value to return if calculated row exceeds the boundaries of the window frame. (Optional - default value of column type when omitted).
- value evaluated at the row that is offset rows after the current row within the ordered frame.
lead function to return a list of successive winners in the physics category.
Query
Query
Query