select month(create_time) as month,
count(*) as count
from 签到表
where create_time > DATE_SUB(CURDATE(),INTERVAL 1 YEAR)
group by month(create_time)
sql统计每月签到数量
最新推荐文章于 2024-05-22 09:05:52 发布
select month(create_time) as month,
count(*) as count
from 签到表
where create_time > DATE_SUB(CURDATE(),INTERVAL 1 YEAR)
group by month(create_time)