Page History

...

Window function call ::= function_name(arg1, arg2, ... argN) OVER (frame_var AS)? 
   ( (PARTITION BY expr1, expr2, …. exprN)? (ORDER BY exprA, exprB, … exprN)? Frame_Spec? )

...

from emp select array_sum((from w select value w.emp.salary)) over w as (partition by … emp.dept) 

Design

The following components were added:

...