oracle按每天,每周,每月,每季度,每年查詢統計資料____oracle

//按天統計
select count(dataid) as 每天運算元量, sum()
from tablename

group by trunc(createtime, 'DD'))

//按自然周統計 
select to_char(date,'iw'),sum() 
 from  tablename
 group by to_char(date,'iw') 
 //按自然月統計 
select to_char(date,'mm'),sum() 
 from   tablename
 group by to_char(date,'mm') 

 //按季統計 
select to_char(date,'q'),sum() 
 from  tablename
 group by to_char(date,'q') 

 //按年統計 
select to_char(date,'yyyy'),sum() 
 from  tablename
 group by to_char(date,'yyyy')

轉載自：http://blog.csdn.net/u011659172/article/details/40186009