摘要: --天select to_char(a.effective_date, 'DD'), sum(a.entered_cr) from gl_je_lines a group by to_char(a.effective_date, 'DD');--月select to_char(a.effective_date, 'MM'), sum(a.entered_cr) from gl_je_lines a group by to_char(a.effective_date, 'MM');--年 select to_char(a.effec 阅读全文
posted @ 2012-03-05 17:08 小波Ooo 阅读(2354) 评论(0) 推荐(0) 编辑