select InputOrgID ,
sum(case EWClass when '1' then 1 else 0 end) as EWClass1,--统计1出现的次数
sum(case EWClass when '2' then 1 else 0 end) as EWClass2,--统计2出现的次数
sum(case status when '1' then 1 else 0 end) as status
from RISK_SIGNAL
group by InputOrgID
sum(case EWClass when '1' then 1 else 0 end) as EWClass1,--统计1出现的次数
sum(case EWClass when '2' then 1 else 0 end) as EWClass2,--统计2出现的次数
sum(case status when '1' then 1 else 0 end) as status
from RISK_SIGNAL
group by InputOrgID
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
