Question

asp 求和

ACC数据库
表名：shoulan
id dh hj
1 55265 10.2
4 55267 8
5 55278 12
6 55342 6.4

如何求出：hj的总和
怎么写？求肋！

Answer 1

<% set rs=conn.Execute("select sum(hj) as num from shoulan") %>
<%=rs("num")%>

希望对楼主有帮助

Answer 2

set rs=conn.excute("select sum(hj) from shoulan")