SQL 求两个字段和的百分比 怎么写？

[fayxue]

sum(字段1)/sum(字段2)是我自己写的 不对， 查询分析器里 结果是“0”，但实际不应该是。还有我要的是个用“%”显示这些数据怎么做？比如（80.5%）这样的结果.

[wzy_love_sly]

declare @tb table (a int,b int)
insert into @tb select 50,80
select ltrim(cast(a*1.0/b as decimal(5,2)))+'%' from @tb

0.63%

[wzy_love_sly]

declare @tb table (a int,b int)
insert into @tb select 50,80
select ltrim(cast(sum(a)*1.0/sum(b) as decimal(5,2)))+'%' as '百分比'  from @tb

0.63%

[dfdsfdsfsfsafsdfsdf]

select cast(sum(f1)/sum(f1)*100 as varchar(10)) + "%"
from t1

[Limpire]

ltrim(convert(numeric(), 100.0*sum(字段1)/sum(字段2)))+'%'

[lff642]

select convert(varchar(10),cast(1.0/2 as decimal(10,2))*100)+'%' result

/*

 result 
------
50.00%
*/