Table of Contents

Enum WindowBoundary

Namespace
Datafication.Core.Data
Assembly
Datafication.Core.dll

Defines the boundary type for window frame specifications. Used in ROWS BETWEEN and RANGE BETWEEN clauses for window functions.

public enum WindowBoundary

Fields

CurrentRow = 2

The current row only. Equivalent to SQL: CURRENT ROW

Following = 3

N rows after the current row (requires offset parameter). Equivalent to SQL: N FOLLOWING

Preceding = 1

N rows before the current row (requires offset parameter). Equivalent to SQL: N PRECEDING

UnboundedFollowing = 4

End of the partition (all rows from current to partition end). Equivalent to SQL: UNBOUNDED FOLLOWING

UnboundedPreceding = 0

Start of the partition (all rows from partition start to current). Equivalent to SQL: UNBOUNDED PRECEDING