php sql按年统计,SQL按照日、周、月、年统计数据

最新推荐文章于 2023-03-02 18:16:01 发布

手机队长

最新推荐文章于 2023-03-02 18:16:01 发布

阅读量215

点赞数

文章标签： php sql按年统计

写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])，

本文原创发布php中文网，转载请注明出处，感谢您的尊重！