问题真多啊asp怎么做求和的啊

[aliketen]

如我在数据库里select了特定的数据RS("money")出来,怎么把这些数据做求和处理?

[pj0643]

可以使用sql中的sum()函数
或者在程序中循环累加

[lbd8848]

select sum(momey) as s from table

[xieyj]

select sum(momey) as mysum from yourtable

[erlzj]

sum()
用法是什么？

[PPLUNCLE]

如果类型不是int或货币型的话,只能先转换,然后在用循环相加!
for i=0 to rs.recordcount
summoney=summoney+rs("money")
rs.movenext
if rs.eof then exit for
next
如果是int型的话,就直接用
select sum(momey) as s from table

[PPLUNCLE]

如果类型不是int或货币型的话,只能先转换,然后在用循环相加!
for i=0 to rs.recordcount
summoney=summoney+cint(rs("money"))
rs.movenext
if rs.eof then exit for
next
如果是int型的话,就直接用
select sum(momey) as s from table

[erlzj]

http://haoya.nease.net/data/bhdfia.htm

[Purpleendurer]

select sum(momey) as mysum from yourtable

[aliketen]

select sum(momey) as mysum from yourtable
sum(momey)怎么显示出来呢?

[erlzj]

Response.Write "<BR>Sum: " & rs(0)

[aliketen]

???不行?


Set rst= Server.CreateObject("ADODB.Recordset")

sqlt="select sum(MONEY) from orders"

rst.open sqlt,conn,1,1

TT = rst(0)

Response.Write TT

rst.close

[wsd315]

select sum(momey) as yousum from table