使用分析功能并实现这一目标
create table tst (x number);insert into tst values (1);insert into tst values (2);insert into tst values (3);insert into tst values (4);insert into tst values (5);select x, sum(x) over (order by x) as y from tst;
使用分析功能并实现这一目标
create table tst (x number);insert into tst values (1);insert into tst values (2);insert into tst values (3);insert into tst values (4);insert into tst values (5);select x, sum(x) over (order by x) as y from tst;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
