SELECT ComeArea,cast((Sum(TotalNum)/cast( (SELECT Sum(TotalNum) from VisitAreaView) as float))*100 as numeric(18,0)) from VisitAreaView group by ComeArea
分组查询 求除法取两位小数
SELECT ComeArea,cast((Sum(TotalNum)/cast( (SELECT Sum(TotalNum) from VisitAreaView) as float))*100 as numeric(18,0)) from VisitAreaView group by ComeArea
分组查询 求除法取两位小数