select count(*) as count,DATE_SUB(‘2016-10-04‘,INTERVAL regDay DAY) from result_1005 group by DATE_SUB(‘2016-10-04‘,INTERVAL regDay DAY) ORDER BY COUNT desc
数据库Mark.2
原文：http://www.cnblogs.com/crac/p/5933293.html
