摘要：
表:consume_record字段:consume (money类型)date (datetime类型)四条sql语句分别按日,按周,按月,按季统计消费总量.如:1月 1200元2月 3400元3月 2800元-–按日 select sum(consume),day([date]) from consume_record where year([date]) = ’2010′ group by day([date]) -–按周quarter select sum(consume),datename(week,[date]) from consume_record where year([da 阅读全文
