17,086
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE csz1
(
xx VARCHAR2(50),
km VARCHAR2(50),
rq VARCHAR2(50),
jdfx VARCHAR2(50),
je NUMBER(20,8)
)
insert into csz1 values ('北京一中', '笔记本', '2014/9/18', '0', 600);
insert into csz1 values ('北京一中', '笔记本', '2014/9/18', '0', 300);
insert into csz1 values ('北京一中', '笔记本', '2014/9/18', '1', 300);
insert into csz1 values ('北京一中', '笔记本', '2014/9/18', '1', 300);
insert into csz1 values ('北京一中', '笔记本', '2014/9/18', '1', 400);
insert into csz1 values ('北京一中', '打印机', '2014/9/18', '0', 500);
insert into csz1 values ('北京一中', '打印机', '2014/9/18', '1', 500);
insert into csz1 values ('北京二中', '打印机', '2014/9/18', '0', 200);
insert into csz1 values ('北京二中', '打印机', '2014/9/18', '0', 300);
insert into csz1 values ('北京二中', '打印机', '2014/9/18', '1', 100);
insert into csz1 values ('北京二中', '打印机', '2014/9/18', '1', 300);
select xx,km,rq,sum(借方),sum(贷方)
from(
select xx,km,rq, je 借方,0 贷方 from csz1 where jdfx='0'
union all
select xx,km,rq, 0 借方,je 贷方 from csz1 where jdfx='1')
group by xx,km,rq
select xx,km,rq,
sum(decode(jdfx,'0',je)) 借方,
sum(decode(jdfx,'1',je)) 贷方
group by xx,km,rq