循环比较/循环相加的语法使用
select AREA_ID,SUM(AREA_ID)OVER(ORDER BY AREA_ID ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING)
from BAS.DIM_AREA
ORDER BY 1
可以select多个字段,但是SUM处必须为一聚合函数(max、min……),BETWEEN ... AND ...之间数字可以根据需要
进行变动,如下使用则为:
select AREA_ID,SUM(AREA_ID)OVER(PARTITION BY AREA_ID ORDER BY AREA_ID ROWS BETWEEN 2 PRECEDING AND 1 PRECEDING)
from BAS.DIM_AREA
ORDER BY 1
这样的效果是将当前列与前一列相加做为追加列。