我下面写出程序的框架部分
sql="select year(date)&'年'&month(date)&'月份' as ym, pro, sum(number) as sm from table group by 1,2 order by 1,2"
rs.open sql,conn,3
ym2='';
do while not rs.eof
if ym2<>rs("ym") then response.write rs("ym")&"
"
ym2=rs("ym")
response.write rs("pro")&" "&rs("sm")&"
"
rs.movenext
loop
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024