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 宋針還 閱讀(501) 評論(0)  編輯  收藏 所屬分類: SQL
          主站蜘蛛池模板: 两当县| 霍林郭勒市| 沐川县| 罗定市| 临清市| 保山市| 汕头市| 东阳市| 洪江市| 拉萨市| 定州市| 临猗县| 罗源县| 勐海县| 长顺县| 屏山县| 砚山县| 美姑县| 新乡县| 桐城市| 法库县| 隆林| 绿春县| 新郑市| 井冈山市| 新巴尔虎右旗| 临漳县| 梁山县| 怀来县| 宣汉县| 阿拉善盟| 顺义区| 南丹县| 沂源县| 镇原县| 商都县| 万安县| 六盘水市| 麻阳| 新源县| 昌黎县|