select count(dataid) as 每天操作数量,sum()
from tablename
@H_301_1@group by trunc(createtime,'DD'))
@H_301_1@@H_301_1@//按自然周统计
select to_char(date,'iw'),sum()
from tablename
group by to_char(date,'iw')
@H_301_1@//按自然月统计
select to_char(date,'mm'),sum()
from tablename
group by to_char(date,'mm')
@H_301_1@//按季统计
select to_char(date,'q'),'q')
@H_301_1@//按年统计
select to_char(date,'yyyy'),'yyyy')
@H_301_1@转载自：http://blog.csdn.net/u011659172/article/details/40186009
