22,301
社区成员
发帖
与我相关
我的任务
分享有一列数据!想求每行数据占这列数据和的百分比~怎么用SQL语句搞定~感谢帮助!
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
如上所示!
感谢帮助!
1 1/1+2+3+4
2 2/1+2+3+4
3 3/1+2+3+4
4 4/1+2+3+4
如上所示!
感谢帮助!
...全文
请发表友善的回复…
发表回复
Dennis618 2003-10-10
- 打赏
- 举报
select a,cast(a/(select cast(sum(a) as numeric(10,3)) from test8) as numeric(10,3)) from test8
loulanlouzhu 2003-10-09
- 打赏
- 举报
+0.0为啥!?,转成浮点!?
pengdali 2003-10-09
- 打赏
- 举报
select a,cast(cast(a/(select sum(a)+0.0 from 表)*100 as numeric(10,3)) as varchar(10))+'%' b from 表
pengdali 2003-10-09
- 打赏
- 举报
select a,cast(a/(select sum(a)+0.0 from 表) as numeric(10,3)) b from 表
loulanlouzhu 2003-10-09
- 打赏
- 举报
1.000%
loulanlouzhu 2003-10-09
- 打赏
- 举报
如果要保留三位小数呢!?
pengdali 2003-10-09
- 打赏
- 举报
select a,cast(a/(select sum(a)+0.0 from 表)*100 as int) b from 表
miller3000 2003-10-09
- 打赏
- 举报
select a, a/b.sumValue from
table1,(select sum(table1.a) as sumValue)b
table1,(select sum(table1.a) as sumValue)b
pengdali 2003-10-09
- 打赏
- 举报
select a,a/(select sum(a) from 表) b from 表
