数据库Mark.2

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

　　

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/crac/p/5933293.html