Skip to main content
Returns a value evaluated at the row that is at a specified physical offset before the current row within the ordered frame. This function is similar to lagInFrame, but always reads the whole partition; a window frame, if specified, is ignored. Syntax
For more detail on window function syntax see: Window Functions - Syntax. Parameters
  • x — Column name.
  • offset — Offset to apply. (U)Int*. (Optional - 1 by default).
  • default — Value to return if calculated row exceeds the boundaries of the window frame. (Optional - default value of column type when omitted).
Returned value
  • Value evaluated at the row that is at a specified physical offset before the current row within the ordered frame.
Example This example looks at historical data for a specific stock and uses the lag function to calculate a day-to-day delta and percentage change in the closing price of the stock.
Query
Query
Response