Rumah >pangkalan data >tutorial mysql > SQL按照日、周、月、年统计数据
SQL按照日、周、月、年统计数据
- WBOYasal
- 2016-06-07 17:38:061270semak imbas
写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 y
写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 where year([date]) = '2006' group by month([date])
--按季
select sum(consume),datename(quarter,[date]) from consume_record where year([date]) = '2006' group by datename(quarter,[date])
--按年
select sum(consume),year([date]) from consume_record where group by year([date])
，