snowflake.snowpark.Window.rowsBetween¶
- static Window.rowsBetween(start: int, end: int) WindowSpec [source]¶
Returns a
WindowSpec
object with the row frame clause.- Parameters:
start – The relative position from the current row as a boundary start (inclusive). The frame is unbounded if this is
Window.UNBOUNDED_PRECEDING
, or any value less than or equal to -9223372036854775807 (-sys.maxsize
).end – The relative position from the current row as a boundary end (inclusive). The frame is unbounded if this is
Window.UNBOUNDED_FOLLOWING
, or any value greater than or equal to 9223372036854775807 (sys.maxsize
).
Note
You can use
Window.UNBOUNDED_PRECEDING
,Window.UNBOUNDED_FOLLOWING
, andWindow.CURRENT_ROW
to specifystart
andend
, instead of using integral values directly.