漂渺影子的专栏

//按自然周统计 select to_char(date,iw),sum() from where group by to_char(date,iw) //按自然月统计 select to_char(date,mm),sum() from where group by to_char(date,mm) //按季统计 select to_char(date,q),sum() fr