select fenbu,
--第一批
sum(case pinum when '1' then fhstate end) /
count(case pinum when '1' then fhstate end) as '第一批送达率',
--第二批
sum(case pinum when '2' then fhstate end) /
count(case pinum when '2' then fhstate end) as '第二批送达率',from view_fhbg
group by fenbu
不知道这样的格式是不是对的
--第一批
sum(case pinum when '1' then fhstate end) /
count(case pinum when '1' then fhstate end) as '第一批送达率',
--第二批
sum(case pinum when '2' then fhstate end) /
count(case pinum when '2' then fhstate end) as '第二批送达率',from view_fhbg
group by fenbu
不知道这样的格式是不是对的
下面就是转换的例子
cast(cast(送达数 as decimal(13,2))/分配数 as decimal(13,2)) as 分配率
-- 也可以直接 乘一下 1.0,也会转成小数。
select fenbu,
--第一批
sum(case pinum when '1' then fhstate end) * 1.00 /
count(case pinum when '1' then fhstate end) as '第一批分配数',
select fenbu,pinum,sum(fhstate)*1./count(fhstate) as 分配率
from view_fhbg
group by fenbu,pinum