SELECT
DATE_FORMAT(call_begin_time, '%Y-%m'), count(1)
FROM
qy_riskcontrol_prod.phone_statements
WHERE
phone_id = 1
GROUP BY DATE_FORMAT(call_begin_time, '%Y-%m');
mysql 按照月份统计
最新推荐文章于 2024-05-29 16:05:24 发布
SELECT
DATE_FORMAT(call_begin_time, '%Y-%m'), count(1)
FROM
qy_riskcontrol_prod.phone_statements
WHERE
phone_id = 1
GROUP BY DATE_FORMAT(call_begin_time, '%Y-%m');