D delphi_newer Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-15 #1 表a 字段 col1 col2 1 10 2 90 如何计算比率。结果输出 col1 col2 col3 1 10 10% 2 90 90%
J jsxjd Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-15 #5 用计算字段 或在 select 时，将数值型转换成字符型，再加上一个'%'
S sanwen Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-15 #6 10%和90%是如何来的.10除100,90除100吗?
B bamboowzm Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-15 #7 pardox 如下： select col1, col2, (cast( cast(numm*100/(select sum(numm) from nnn ) as integer) as varchar(10)) + '%') col3 from tablename
pardox 如下： select col1, col2, (cast( cast(numm*100/(select sum(numm) from nnn ) as integer) as varchar(10)) + '%') col3 from tablename
D delphi_newer Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-15 #8 是阿。我意思没表述清楚? 第三列的数值就是相对应第二列对应的数值除以第二行的sum值。
B bamboowzm Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-15 #9 不好意思，写错了！ paradox 如下： select col1, col2, (cast( cast(numm*100/(select sum(numm) from tablename ) as integer) as varchar(10)) + '%') col3 from tablename
不好意思，写错了！ paradox 如下： select col1, col2, (cast( cast(numm*100/(select sum(numm) from tablename ) as integer) as varchar(10)) + '%') col3 from tablename
D dz2050 Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-15 #10 select col1 , col2 , col2 / ( select sum(col2) from table1) as col3 from table1
F freaky7090 Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-15 #11 for Access SELECT a.col1, a.col2, a.col2/(select sum(col2) from a) AS col3 FROM a
