select t.l_contractserialno,
t.d_cdate,
t.c_cserialno,
t.f_occurshares,
NVL(SUM(t.F_OCCURSHARES)
OVER(PARTITION BY t.L_CONTRACTSERIALNO ORDER BY t.D_CDATE,
t.C_CSERIALNO ROWS BETWEEN unbounded preceding AND current row),
0) f_lastshares
from tsharecurrents t
开窗函数递归累加
最新推荐文章于 2021-09-29 15:55:37 发布