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
          主站蜘蛛池模板: 巴林左旗| 布尔津县| 朝阳区| 保山市| 通海县| 来宾市| 土默特右旗| 阿巴嘎旗| 青川县| 玉田县| 凤城市| 东台市| 游戏| 仁寿县| 金川县| 靖边县| 宝坻区| 巩留县| 湄潭县| 顺昌县| 鄱阳县| 拜泉县| 佛教| 宜良县| 宿迁市| 瓦房店市| 榆中县| 安丘市| 鄂温| 永康市| 唐山市| 焦作市| 正安县| 枣强县| 仙桃市| 安塞县| 独山县| 新乐市| 彭水| 江城| 温泉县|