假设transDate的格式为 '20151010'
按日统计 select trans.transDate,count(trans.fid),sum(trans.transAmt) from TTrans trans group by trans.transDate
按周统计 select DATEPART(ISO_WEEK,trans.transDate) as transDate,count(trans.fid),sum(trans.transAmt) from TTrans trans group by DATEPART(ISO_WEEK,trans.ftransDate)
按月统计 select convert(varchar(7),cast(trans.transDate as date),120) as transDate,count(trans.fid),sum(trans.transAmt) from TTrans trans group by convert(varchar(7),cast(trans.transDate as date),120)