A window expr that takes the form of a built in window function
State for each unique partition determined according to PARTITION BY column(s)
A window expr that takes the form of an aggregate function
Aggregate Window Expressions that have the form
OVER({ROWS | RANGE| GROUPS} BETWEEN UNBOUNDED PRECEDING AND ...)
e.g cumulative window frames uses PlainAggregateWindowExpr
. Where as Aggregate Window Expressions
that have the form OVER({ROWS | RANGE| GROUPS} BETWEEN M {PRECEDING| FOLLOWING} AND ...)
e.g sliding window frames uses SlidingAggregateWindowExpr
.
A window expr that takes the form of an aggregate function
Aggregate Window Expressions that have the form
OVER({ROWS | RANGE| GROUPS} BETWEEN UNBOUNDED PRECEDING AND ...)
e.g cumulative window frames uses PlainAggregateWindowExpr
. Where as Aggregate Window Expressions
that have the form OVER({ROWS | RANGE| GROUPS} BETWEEN M {PRECEDING| FOLLOWING} AND ...)
e.g sliding window frames uses SlidingAggregateWindowExpr
.