可以用DateAdd函数
DATEADD ( datepart , number, date )
请参考:
日期部分 缩写
Year yy, yyyy
quarter qq, q
Month mm, m
dayofyear dy, y
Day dd, d
Week wk, ww
Hour hh
minute mi, n
second ss, s
millisecond ms
create table #abc ([a] [varchar] (255) NULL ,[b] int NULL )
insert into #abc(a,b)values('a1',2)
insert into #abc(a,b)values('b1',3)
insert into #abc(a,b)values('c2',4)
insert into #abc(a,b)values('a1',3)
insert into #abc(a,b)values('b2',2)
insert into #abc(a,b)values('b1',6)
--select * from #abc
select a,sum(b)as b from #abc group by a --//这是你要的结果
drop table #abc
然后只能是循环取和了。对不起,我帮不了你了。
<%
sql="SELECT DISTINCT a FROM abc Order BY a"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
if rs.recordcount<>0 then
while not rs.eof
set temp=server.createobject("adodb.recordset")
temp.open "select sum(b) as expr1 from abc where a='"&rs("a")&"'",conn,1,3
%>
<%=rs("a")%>:<%=temp("expr1")%>
<%
temp.close
set temp=nothing
rs.movenext
wend
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>