--按天统计
select to_char(rdate,'dd'),sum(r.added) from revision r group by to_char(rdate,'dd');
--按周统计
select to_char(rdate,'iw'),sum(r.added) from revision r group by to_char(rdate,'iw');
--按月统计
select to_char(rdate,'mm'),sum(r.added) from revision r group by to_char(rdate,'mm');
--按季统计
select to_char(rdate,'q'),sum(r.added) from revision r group by to_char(rdate,'q');
--按年统计
select to_char(rdate,'yyyy'),sum(r.added) from revision r group by to_char(rdate,'yyyy');
select to_char(rdate,'dd'),sum(r.added) from revision r group by to_char(rdate,'dd');
--按周统计
select to_char(rdate,'iw'),sum(r.added) from revision r group by to_char(rdate,'iw');
--按月统计
select to_char(rdate,'mm'),sum(r.added) from revision r group by to_char(rdate,'mm');
--按季统计
select to_char(rdate,'q'),sum(r.added) from revision r group by to_char(rdate,'q');
--按年统计
select to_char(rdate,'yyyy'),sum(r.added) from revision r group by to_char(rdate,'yyyy');