SQL按照日、周、月、年统计数据的方法分享

–按日 select sum(consume),day([date]) from consume_record where year([date]) = ‘2006’ group by day([date]) –按周quarter select sum(consume),datename(week,[date]) from consume_record where year([date]) = ‘2006’ group by datename(week,[date]) –按月 select sum(consume),month([date]) from consume_record wh