SELECT DATE_FORMAT(CREATE_TIME ,"%Y年%m月") AS dates,COUNT(*) FROM tablename
GROUP BY DATE_FORMAT(CREATE_TIME,"%Y年%m月")
ORDER BY DATE_FORMAT(CREATE_TIME,"%Y年%m月") DESC ;
整段代码的意思是:从tablename表中 查询日期(CREATE_TIME)(将日期按照"%Y年%m月"格式)并作为dates,统计数量(count(*)),按照日期分组 GROUP BYDATE_FORMAT(CREATE_TIME,"%Y年%m月"),并降序 ORDER BY DATE_FORMAT(CREATE_TIME,"%Y年%m月") DESC 。