关于统计

按小时

select CONVERT(varchar(13),createdtime,120)+':00:00' as adddate1,count(*) as allhour from [User] group by CONVERT(varchar(13),CreatedTime ,120)  

 

--按日
selectsum([统计字段]),day([时间字段]) from 表明 whereyear([时间字段]) ='2009'groupbyday([时间字段])

--按周
selectsum([统计字段]),datename(week,[时间字段]) from consume_record whereyear([时间字段]) ='2009'groupbydatename(week,[时间字段])

--按月
selectsum([统计字段]),month([时间字段]) from consume_record whereyear([时间字段]) ='2009'groupbymonth([时间字段])

--按季
selectsum([统计字段]),datename(quarter,[时间字段]) from consume_record whereyear([时间字段]) ='2009'groupbydatename(quarter,[时间字段])

posted @ 2013-05-21 15:41  txbauo  阅读(80)  评论(0)  编辑  收藏  举报