随笔分类 -  sql语句

一些很有用的sql语句，在做一些很散的功能点时有用到
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) 阅读全文

posted @ 2012-07-27 18:10 yxfaction 阅读(510) 评论(0) 推荐(0)

导航