有一列数据!想求每行数据占这列数据和的百分比~怎么用SQL语句搞定~感谢帮助!

[loulanlouzhu]

a b
1 1/1+2+3+4
2 2/1+2+3+4
3 3/1+2+3+4
4 4/1+2+3+4


如上所示!




感谢帮助!

[pengdali]

select a,a/(select sum(a) from 表) b from 表

[miller3000]

select a, a/b.sumValue from
table1,(select sum(table1.a) as sumValue)b

[pengdali]

select a,cast(a/(select sum(a)+0.0 from 表)*100 as int) b from 表

[loulanlouzhu]

如果要保留三位小数呢!?

[loulanlouzhu]

1.000%

[pengdali]

select a,cast(a/(select sum(a)+0.0 from 表) as numeric(10,3)) b from 表

[pengdali]

select a,cast(cast(a/(select sum(a)+0.0 from 表)*100 as numeric(10,3)) as varchar(10))+'%' b from 表

[loulanlouzhu]

+0.0为啥!?,转成浮点!?

[Dennis618]

select a,cast(a/(select cast(sum(a) as numeric(10,3)) from test8) as numeric(10,3)) from test8