不好意思,我发现我这边的情况比这个复杂,这条语句好像还是搞不定:
大家可以先执行下面语句:
drop table t1 cascade constraints purge;
create table t1(a number(3),b number(3),c varchar2(4));
insert into t1(a,b,c) values(1,34,'aa');
insert into t1(a,b,c) values(1,35,'ee');
insert into t1(a,b,c) values(2,45,'aa');
insert into t1(a,b,c) values(3,24,'ee');
insert into t1(a,b,c) values(4,55,'aa'); 然后我需要的结果是:
A C B
1 aa 34
1 ee 35
2 aa 34+45
3 ee 35+24
4 aa 34+45+55 请问这个该怎么写呢?这条语句好像不对:SELECT a,c,SUM(b) OVER(ORDER BY a,c) FROM t1
大家可以先执行下面语句:
drop table t1 cascade constraints purge;
create table t1(a number(3),b number(3),c varchar2(4));
insert into t1(a,b,c) values(1,34,'aa');
insert into t1(a,b,c) values(1,35,'ee');
insert into t1(a,b,c) values(2,45,'aa');
insert into t1(a,b,c) values(3,24,'ee');
insert into t1(a,b,c) values(4,55,'aa'); 然后我需要的结果是:
A C B
1 aa 34
1 ee 35
2 aa 34+45
3 ee 35+24
4 aa 34+45+55 请问这个该怎么写呢?这条语句好像不对:SELECT a,c,SUM(b) OVER(ORDER BY a,c) FROM t1
select t.*,sum(b)over(order by b) from t1 t;
select t.*,sum(b)over(partition by c order by a,c) from t1 t;