如何计算从数据库中查询到的记录中某字段的所有值的和？

帮帮忙！
---------------------------------------------------------------

加入现在有一个表为table，其中有count字段，记录每天的访问量，那么

1   
2set objCon=server.createobject("adodb.connection")   
3...............   
4set objRs=server.createobject("adodb.recordset")   
5strSql="select sum(counter) as intTotal from table"   
6'select sum(字段名) 取得该字段的总和   
7objRs.open strSql,objCon,3,3

总访问量：``` =objRs("intTotal")

objRs.close
set objRs=nothing
objCon.close
set objCon=nothing

 1\---------------------------------------------------------------   
 2  
 3select sum(price) as total_price from tb_name   
 4\---------------------------------------------------------------   
 5  
 6用Where语句筛选呀   
 7\---------------------------------------------------------------   
 8  
 9select sum(price) as total_price from tb_name where price&gt;300   
10\---------------------------------------------------------------   
11  
12select name,number,sum(price) as total_price from tb_name where price&gt;300 group by name,number