$sql = "select A1,sum(if(A10 like '2022-08-01%',1,0)) as AB1 from Shop_Name where
A10 between '2022-08-01 00:00:00' and '2022-08-31 23:59:59' group by A1 order by A5 ASC";
其中:
A1是店铺名,如天猫1号店
A10是客户下单时间,如:2022-08-05 12:30:21
A5是销售金额,如:33.00
现在AB1的值是这段时间的下单笔数,我想得当天金额汇总,请高手指点,代码如何写?
MYSQL的汇总求和问题
最新推荐文章于 2024-05-18 14:06:20 发布