SELECT
count(a.id) AS '数量',
DAY (a.create_date) AS '时间'
FROM
test aWHERE
MONTH (a.create_date) = MONTH (NOW())
GROUP BY
DAY (a.create_date)
SELECT
count(a.id) AS '数量',
DAY (a.create_date) A
阅读背景：
sql查询当前月每天的数据统计量
来源：互联网
分享到：
