select sum(alert.Host) ,sum(alert.Device)
from
(
select substr(t.eventid,1,2) pcode,
sum(case when r.classname='Host' then 1 else null end) Host,
sum(case when r.classname<>'Host' then 1 else null end) Device
from alert1 t,
(
select name,classname from object
where parent_node_res_id=0
) r
where t.parentnode=r.mo_name
and t.severity<=4
group by substr(t.eventid,1,2)
) alert,dict_province prov
where alert.pcode(+)=prov.uploadcode
group by prov.managerareaname,prov.uploadcode||prov.provinceshort
用了sum但是不显示合计?为什么?
from
(
select substr(t.eventid,1,2) pcode,
sum(case when r.classname='Host' then 1 else null end) Host,
sum(case when r.classname<>'Host' then 1 else null end) Device
from alert1 t,
(
select name,classname from object
where parent_node_res_id=0
) r
where t.parentnode=r.mo_name
and t.severity<=4
group by substr(t.eventid,1,2)
) alert,dict_province prov
where alert.pcode(+)=prov.uploadcode
group by prov.managerareaname,prov.uploadcode||prov.provinceshort
用了sum但是不显示合计?为什么?
4+null=null
4+0=0
case when r.classname='Host' then 1 else null end
是不是改成case when r.classname='Host' then 1 else 0 end