窗口函数通常是对组内数据进行处理,所以一定需要分组操作(partition by) 通常的语法是
select
WINDOW(a.val)over(PARTITION by a.col1 order by a.col2 asc [rows BETWEEN xxx PRECEDING and CURRENT ROW])
from a
select
WINDOW(a.val)over(PARTITION by a.col1 order by a.col2 asc [rows BETWEEN xxx PRECEDING and CURRENT ROW])
from a