create table T( name varchar2(100) null,score number null); insert into T values('a',10); insert into T values('b',20); insert into T values('a',30); insert into T values('b',40); insert into T values('a',50); insert into T values('b',60); select * from T select name,sum(score) from T GROUP BY namesum 你可以换成 avg min max 等等 聚合函数 自己试下吧
insert into T values('a',10);
insert into T values('b',20);
insert into T values('a',30);
insert into T values('b',40);
insert into T values('a',50);
insert into T values('b',60);
select * from T
select name,sum(score) from T GROUP BY namesum 你可以换成 avg min max 等等 聚合函数
自己试下吧