主要为大家按日，星期，月，季度，年统计销售额的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