select org.company_name,
sum(1) final_amount,
sum(nvl(t.worth, 0)) final_worth
from eams_master t,
(select t1.company_name, t1.org_objid
from sys_org t1
where t1.company_code is not null) org
where to_date(t.start_time, 'YYYY-MM-DD') <
to_date('2013-02-28', 'YYYY-MM-DD')
and t.class_rid in
('FT10', 'FT20', 'FT30', 'FT40', 'FT50', 'FT60', 'FT70')
and state in ('001', '002', '003', '004', '005', '010', '011')
and t.org_objid in
(select o.org_objid
from sys_org o
start with o.org_objid = org.org_objid
connect by prior o.org_objid = o.parentid)
group by org.company_name
date
sum(1) final_amount,
sum(nvl(t.worth, 0)) final_worth
from eams_master t,
(select t1.company_name, t1.org_objid
from sys_org t1
where t1.company_code is not null) org
where to_date(t.start_time, 'YYYY-MM-DD') <
to_date('2013-02-28', 'YYYY-MM-DD')
and t.class_rid in
('FT10', 'FT20', 'FT30', 'FT40', 'FT50', 'FT60', 'FT70')
and state in ('001', '002', '003', '004', '005', '010', '011')
and t.org_objid in
(select o.org_objid
from sys_org o
start with o.org_objid = org.org_objid
connect by prior o.org_objid = o.parentid)
group by org.company_name
date
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货