oracle 按年，季度，月，周统计SQL

按照每周进行统计
 select to_char(sysdate,'ww') from dual group by to_char(sysdate,'ww');

 

按照每月进行统计
 select to_char(sysdate,'mm') from dual group by to_char(sysdate,'mm');

 

按照每季度进行统计
 select to_char(sysdate,'q') from dual group by to_char(sysdate,'q');

 

按照每年进行统计
 select to_char(sysdate,'yyyy') from dual group by to_char(sysdate,'yyyy');