根据时间字段(月)分组统计数量
SELECT DATE_FORMAT(check_date,"%Y-%m") AS dates,COUNT(*) FROM xx GROUP BY DATE_FORMAT(check_date,"%Y-%m") ORDER BY DATE_FORMAT(check_date,"%Y-%m") DESC ;
根据日期字段与现在时间做比较统计(例如:202004月份的数据,与系统时间04月份比较,统计。)
select count(*) from ht_potential_risks where date_sub(curdate(), interval 1 month) <= date(check_date);