select 'spzj' as 'proname',count(spzz) as 'count',cast(cast(count(spzz)*100 as float)) /(count(spzz)+count(hqgj)+count(spgj)+count(hqzz)+count(jjsy)) as numeric(10,2)) as 'bl' from VIEW_bjdjbtj union
select 'hqgj' as 'proname',count(hqgj),cast((count(spzz)/count(*)) as numeric(10,2)) from view_bjdjbtj
select 'hqgj' as 'proname',count(hqgj),cast((count(spzz)/count(*)) as numeric(10,2)) from view_bjdjbtj
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货