select  DATE_FORMAT(releaseTime,"%Y-%m"),count(DATE_FORMAT(releaseTime,"%Y-%m")) from logsinfo group by DATE_FORMAT(releaseTime,"%Y-%m") order by logsinfoid desc


 

使用mysql 自己提供的 DATE_FORMAT 可以进行的排序。