例：
SELECT DATE_FORMAT(`create_time`, '%Y-%m-%d') AS days,COUNT(1) AS num FROM `dc_loan_aa_orders` GROUP BY DATE_FORMAT(`create_time`, '%Y-%m-%d') ORDER BY create_time DESC
结果集如下：
本文共 227 字，大约阅读时间需要 1 分钟。
例：
SELECT DATE_FORMAT(`create_time`, '%Y-%m-%d') AS days,COUNT(1) AS num FROM `dc_loan_aa_orders` GROUP BY DATE_FORMAT(`create_time`, '%Y-%m-%d') ORDER BY create_time DESC
结果集如下：
转载于:https://www.cnblogs.com/007sx/p/9761153.html