select sum(AAA) 合计 from test group by year(rq),month(rq),day(rq)
哦!看错了题目!呵呵!愿赌服输兄是对的! GETDATE()取得今天的日期是: select CONVERT(varchar(10),getDate(),120) 按照当天,当月,当年合计是: select sum(AAA) 合计 from test group by day(rq),month(rq),year(rq)
楼主好像要的是三个查询结果吧? select sum(AAA) 合计 from test group rq (按天) select sum(AAA) 合计 from test group by month(rq) + year(rq)(按月) select sum(AAA) 合计 from test group by year(rq)(按年)
convert(char(8),date,112) ----20020101
GETDATE()取得今天的日期是:
select CONVERT(varchar(10),getDate(),120)
按照当天,当月,当年合计是:
select sum(AAA) 合计 from test group by day(rq),month(rq),year(rq)
select sum(AAA) 合计 from test group rq (按天)
select sum(AAA) 合计 from test group by month(rq) + year(rq)(按月)
select sum(AAA) 合计 from test group by year(rq)(按年)