ls1120623840的博客

从订单表选择6个月的商品销售量前十两表关联查询 SELECT or_goods_id,go_name,SUM(or_count) as count from tb_order AS a LEFT JOIN tb_goods AS b ON a.or_goods_id=b.go_id where or_datetime>DATE_SUB(CURDATE(), INTERVAL 6 MON...

mysql 查询当天、本周，本月，上一个月的数据 https://www.cnblogs.com/benefitworld/p/5832897.html