SQL获取当天的记录数按年月日降序

select COUNT(1) ,DATENAME(year ,createdate) as Year,DATENAME(month,createdate) as Month,Datename(day, createdate) as Day   from bbs_topic group by Datename(day, createdate),Datename(month, createdate),Datename(year, createdate)