sql求百分比,根据jlh 求money字段占moeny字段的总和,数据库只有money,jl...答:select a.jlh,a.money,substring(convert(varchar(100),(a.money/b.sumMoney)*100),1,5)+'%' as scale,case when a.money=c.maxmoney then '控股' else '持股' end as [属性] from table1 a inner join(select jlh,sum(money) as sumMoney from table1 group by(jlh)) b on a....