按照每周进行统计
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');