常用SQL笔记MySQL
2025-04-08 23:52阅读:49评论:0
MySQL之统计近七天的数量
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
-- 返回的是某月某日的数量SELECT monthDay, count( 0 ) AS numb FROM ( SELECT -- 返回的是月日 date_format( create_date, '%m-%d' ) monthDay FROM tb_product WHERE create_date BETWEEN STR_TO_DATE( date_format( date_sub( now(), INTERVAL 7 DAY ), '%Y-%m-%d 00:00:00' ), '%Y-%m-%d %H:%i:%s' ) AND STR_TO_DATE( date_format( date_sub( now(), INTERVAL 1 DAY ), '%Y-%m-%d 23:59:59' ), '%Y-%m-%d %H:%i:%s' ) ) temp GROUP BY temp.monthDay