摘要: oracle 实现按周,月,季度,年查询统计数据//按自然周统计 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... 阅读全文
posted @ 2009-12-05 17:25 单康丽 阅读(2440) 评论(0) 推荐(0) 编辑