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
          主站蜘蛛池模板: 郧西县| 新田县| 陆河县| 思茅市| 启东市| 赤壁市| 托里县| 报价| 屏东市| 通州区| 古浪县| 修文县| 汝南县| 交口县| 渭南市| 安庆市| 山东| 江达县| 尚志市| 千阳县| 达拉特旗| 岑巩县| 长治市| 双峰县| 克拉玛依市| 安西县| 张家口市| 永春县| 林周县| 宾川县| 中卫市| 大兴区| 敦煌市| 晋宁县| 桑植县| 汨罗市| 淮安市| 察哈| 河南省| 宁国市| 定结县|