szhswl
          宋針還的個人空間
          create materialized view v_acct_view refresh complete on demand
          start with sysdate
          next trunc(sysdate+1)+2/24   
          enable query rewrite
          as
          select area.areaname                   areaname,
                 latn.Latnname                   latnname,
                 count(cust.custid)              custid,
                 to_char(vMain.updatedate,'yyyy-mm-dd')             Dday,
                 to_char(vMain.updatedate,'yyyy-mm')                Ymonth,
                 to_char(vMain.updatedate,'q')                      Qquater,
                 count(vMain.acctid)             sum_acctid,
                 sum(vMain.Jftotal)              sum_jftotal,
                 sum(vMain.Jfusable)             sum_jfusable,
                 sum(vMain.Jfconsume)            sum_jfconsume,
                 sum(vMain.Jfinline)             sum_jfinline,
                 sum(vMain.Jfsales)              sum_jfsales,
                 sum(vMain.Jfencourage)          sum_Jfencourage,
                 round(avg(vMain.Jftotal))       avg_jftotal,
                 round(avg(vMain.Jfusable))      avg_jfusable,
                 round(avg(vMain.Jfconsume))     avg_jfconsume,
                 round(avg(vMain.Jfinline))      avg_jfinline,
                 round(avg(vMain.Jfsales))       avg_jfsales,
                 round(avg(vMain.Jfencourage))   avg_Jfencourage
          from acct vMain
          left join latn latn on latn.latnid = vMain.latnid
          left join area area on area.areaid = vMain.areaid
          group by
              latn.latnname,
              area.areaname,
              to_char(vMain.updatedate,'q') ,
              to_char(vMain.updatedate,'yyyy-mm'),
              to_char(vMain.updatedate,'yyyy-mm-dd')


          ---------------------------------------------------------------------------------------------------------------------------------
          說人之短,乃護己之短。夸己之長,乃忌人之長。皆由存心不厚,識量太狹耳。能去此弊,可以進德,可以遠怨。
          http://www.aygfsteel.com/szhswl
          ------------------------------------------------------------------------------------------------------ ----------------- ---------
          posted on 2007-12-03 16:38 宋針還 閱讀(498) 評論(0)  編輯  收藏 所屬分類: SQL
          主站蜘蛛池模板: 辉县市| 汤阴县| 临清市| 厦门市| 大关县| 岚皋县| 高平市| 满城县| 兴国县| 阿城市| 昌平区| 车致| 米易县| 清新县| 山东省| 广西| 汝州市| 阿图什市| 卢氏县| 丽水市| 汝南县| 韩城市| 井陉县| 许昌县| 墨脱县| 朝阳区| 射阳县| 庆元县| 武胜县| 永善县| 金沙县| 白水县| 罗甸县| 福贡县| 望谟县| 天全县| 舟山市| 睢宁县| 射阳县| 洛浦县| 和政县|