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 宋針還 閱讀(506) 評論(0)  編輯  收藏 所屬分類: SQL
          主站蜘蛛池模板: 阿坝县| 恭城| 石门县| 民丰县| 千阳县| 遂昌县| 察隅县| 德保县| 宾川县| 安阳市| 临澧县| 山丹县| 玉溪市| 三原县| 贵港市| 蒙阴县| 周宁县| 蚌埠市| 五原县| 桦甸市| 河津市| 博客| 邵阳县| 四平市| 中超| 枝江市| 睢宁县| 高尔夫| 天门市| 阿克陶县| 东明县| 瑞丽市| 南京市| 佛坪县| 龙海市| 鄂温| 林西县| 赣州市| 沈丘县| 海原县| 潼关县|