select >
sum

get sum of a field

select sum(field name) as anotherName from table where ....

id  product  size  price  
   1 Shorts M 2.99 
   2 T-Short XL 3.99 
   3 Shorts M 5.3 
<%

query=request("query") 'ex: query="M"
fieldQuery=request("fieldQuery") 'ex: fieldQuery="Size"

DIM SQL, RS, conn
SQL="SELECT SUM(price) AS sumTotal from TB where "&fieldQuery&"='"&query&"' "
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open SQL,conn

sumTotal= rs("sumTotal")
rs.close

response.write sumTotal

%>

result:

8.29