SELECTDATE_FORMAT(create_date, '%Y-%m-%d') AS `date`,COUNT(id)AS total,COUNT(type=1OR NULL) AS failTotal
FROM table_name
WHERE test_date BETWEEN #{startDate} AND #{endDate}
GROUP BY `date`
需求:某时间范围内按天分类,统计总数和失败数SELECT DATE_FORMAT(create_date, '%Y-%m-%d') AS `date`, COUNT(id) AS total, COUNT(type=1 OR NULL) AS failTotalFROM table_name WHERE test_date BETWEEN #{startDate} AND #{endDate} GROUP BY `date`注意count(条件表达式