SELECT acc_nbr,
SUM (DECODE (acct_item_, 2005, NVL(charge,0))),
SUM (DECODE (acct_item_, 2005, 0, NVL(charge,0)))
FROM acct_item
GROUP BY acc_nbr
SUM (DECODE (acct_item_, 2005, NVL(charge,0))),
SUM (DECODE (acct_item_, 2005, 0, NVL(charge,0)))
FROM acct_item
GROUP BY acc_nbr
select a.acc_nbr,(case when substr(a.acct_item_,1,1)='1' then sum(a.charge) YZF else sum(a.charge) SJF END) from acct_item a group by a.acc_nbr
a.acc_nbr,
sum(decode(b.bz,'YZF',a.charge,0)) YZF,
sum(decode(b.bz,'SJF',a.charge,0)) SJF
from
table1 a,
table2 b
where
a.acct_item_=b.acct_item_
group by
a.acc_nbr
a.acc_nbr,
sum(decode(b.bz,'YZF',a.charge,0)) YZF,
sum(decode(b.bz,'SJF',a.charge,0)) SJF
from
acct_item a,
item b
where
a.acct_item=b.acct_item
group by
a.acc_nbr
YZF-月租费
SJF-数据费
XXF-信息费
.....
应该有几十项收费吧!
建议加一个字段用以区分统计费用类型
你问一下电信的计费人员,他们应该有一个过程或ProC , 用来生成对应的记录集
__第一歨 建库,
acc_nbr ,yzf,sjf,.....
create tabel aaa--第二歨
将号码插入表中
insert into aaa set select acc_nbr from acct_item group by acc_nbr;
__之后就是一项一项的update 了,
这个数据库是远端的数据库,我修改的权限都没有。只能是访问呀!
去哪里找电信的计费人员呀!