--写sql语句分别按日,星期,月,季度,年统计销售额
--按日
select sum(consume),day([date]) from consume_record where year([date]) = '' group by day([date])
--按周quarter
select sum(consume),datename(week,[date]) from consume_record where year([date]) = '' group by datename(week,[date])
--按月
select sum(consume),month([date]) from consume_record where year([date]) = '' group by month([date])
--按季
select sum(consume),datename(quarter,[date]) from consume_record where year([date]) = '' group by datename(quarter,[date])
--按年
select sum(consume),year([date]) from consume_record where group by year([date])
写sql语句分别按日,星期,月,季度,年统计的相关教程结束。