写sql语句分别按日,星期,月,季度,年统计

--写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])
上一篇:洛谷P3602 Koishi Loves Segments(贪心,multiset)


下一篇:微信小程序添加悬浮在线客服会话按钮