--按天统计
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');
【上篇】使用Microsoft Update升级时遇到 Server Error 403 – Forbidden:Access is denied错误的解决办法
【下篇】下载MSN中奖了哦,开心ing……
【下篇】下载MSN中奖了哦,开心ing……