select 部门=Department, 部门资产数=count(HostSn),总资产数= (select count(SID) from dbo.ComputerInfo)
,百分比=cast(cast(count(HostSn)*1.0*100/(select count(SID) from dbo.ComputerInfo) as decimal(10,2)) as varchar(50)) +'%'
from dbo.HostInfo where Department <>'' group by Department
SQL多表查询结果求百分比
最新推荐文章于 2022-11-23 17:38:18 发布