转自http://www.cnblogs.com/oec2003/archive/2009/06/04/1496541.html
首先创建数据表
Create table Counter( CounterID int identity(1,1) not null, IP varchar(20), AccessDateTime
select distinct(datepart(month,convert(varchar(10),Consumetime,120))) as m ,sum(ConsumeTotal) as cout
from dbo.T_Consume
where datepart(year,convert(varchar(10),Consumetime,120))="2011" and Ph
oracle sql 按年、月、周、日，分组查询统计数据：
1、SQL语句如下
select sum(count),to_char(to_date(ext2,"YYYY-MM-dd"),"iw") from CMS_INDEXPV where site_id = "0002"
and ext2 is not nul
