select bm, person, sum(nvl(cfx,0)) as cfs, sum(nvl(qtfx,0)) as qtfx from tb group by bm, person;
--问问题请把创表语句,初始数据语句发出来 create table t(bm varchar2(50),person varchar(50),cfx int,qtfx int); --插入数据 insert into t values ('发电部','安丽丽',5,0); insert into t values ('发电部','安丽丽',0,0); insert into t values ('检修部门','陈涛',6,0); insert into t values ('技术部','李俊',7,7);select bm,person,sum(cfx),sum(qtfx) from t group by bm,person1 发电部 安丽丽 5 0 2 技术部 李俊 7 7 3 检修部门 陈涛 6 0
select bm,person,sum(cfx),sum(qtfx) from t group by bm,person;
from tb
group by bm, person;
--问问题请把创表语句,初始数据语句发出来
create table t(bm varchar2(50),person varchar(50),cfx int,qtfx int);
--插入数据
insert into t values ('发电部','安丽丽',5,0);
insert into t values ('发电部','安丽丽',0,0);
insert into t values ('检修部门','陈涛',6,0);
insert into t values ('技术部','李俊',7,7);select bm,person,sum(cfx),sum(qtfx) from t group by bm,person1 发电部 安丽丽 5 0
2 技术部 李俊 7 7
3 检修部门 陈涛 6 0