sum(cast req_num as float) 这个用法是不对的
正确的是:
select top 3 calling,sum(case when result=200 then 1 else 0 end)/convert(float,sum(req_num)) as req_num2 from WAP_BDR010317 group by calling
calling req_num2
-------------------------------- ---------------------------
8613711012367 0.700000
8618825042842 0.750000
8613415200578 0.818182