部门间共享与服务平台ipc首页sql

1、共享情况统计 FROM_FILEXWHEREt.DW_IDISNOTGROUPBYt.DW_ID,t.DW_NAME ORDER BY SJL DESC 共享情况统计 FROM_FILEXWHEREt.DW_IDISNOTGROUPBYt.DW_ID,t.DW_NAME ORDER BY SJL DESC FROM WHERE t.DW_ID IS NOT NULL GROUPBYt.DW_ID,t.DW_NAMEORDERBYSJL说明 FROM_CXFYWHEREt.DW_IDISNOT说明selectt.dept_id,t.dept_nameasdeptName,sum(t.dlcs)a

2、sfrom t_sorderbysTimes说明_login是统 from t_sorderbysTimes说明_login是统 SELECTFROM(SELECTT.DW_ID,T.DW_NAME ASDEPTNAME, SUM(T.CZCS) ASFROM_OPERATORWHERET.APP_ID = ANDT.MODULE= GROUPBYT.DW_ID,ORDERBYSUM(T.CZCS) WHERE1 = selectt.dw_id,t.dw_nameasdeptName,sum(t.czcs)asfrom _OPERATORwheret.app_id=andt.module内网门

3、户简项查询 group by t.dw_id, t.dw_nameorderbysum(t.czcs)使用概况数:selectcount(*)fromt_user_out_dwtwheret.deleted from_shzysbtwheret.ll_id :selectcount(distinct(t.dw_id)fromt_user_usert,T_USER_GA_DWt2t.sswl=Iandt.dw_id=t2.bh0000and已共数据:select:selectcount(distinct(t.dw_id)fromt_user_usert,T_USER_GA_DWt2t.sswl=

4、Iandt.dw_id=t2.bh0000and已共数据:select*from已共业务:selectcount(*)from使用趋势:SELECTCOUNT(1)asTJS,SUBSTR(t.CREATE_TIME,1,6)CREATE_TIME FROM T_LOG_FILEX_TASK_INFO tAND CREATE_TIME =to_char(add_months(sysdate,-12),yyyyMM) AND CZRQ to_char(sysdate, yyyyMM) ORDERBY请求服务 FROM_CXFY ANDFWRQto_char(sysdate, ORDERBY战SE

5、LECTDWID,DWNAME,HCCS,HCBDSJL,ROWNUMRNFROM(SELECTDW_IDASDWID,DWNAME,HCCS,FROM ORDERBY战SELECTDWID,DWNAME,HCCS,HCBDSJL,ROWNUMRNFROM(SELECTDW_IDASDWID,DWNAME,HCCS,FROM(SELECT DW_ID, COUNT(L.ID) HCCS FROM (SELECT LEFT OUTER JOIN (SELECT ID, U.DW_ID, FROMT_USER_USERU,T_USER_OUT_DWDWHEREU.DW_ID=D.DW_ID)UON

6、=O.USER_ID WHERE O.MODULE = PPC_WWMHXXHC AND O.S L WHERE L.DW_ID IS NOT NULL GROUP BY DW_ID) T +LEFTOUTER (SELECT DWID AS DW_ID, SUM(L.OPERATOR_DESC) HCB FROM(SELECTO.ID,O.MODULE,O.OPERATOR_DESC,O.USER_ID,U.DW_IDASDWID,U.DW_NAMEASDWNAMEFROMT_LOG_OPERATORO LEFT OUTER JOIN (SELECT ID, U.DW_ID, FROMT_USER_USERU,T_USER_OUT_DWDWHEREU.DW_ID=D.DW_ID)UON=O.USER_IDLWHEREL.DWIDISNOTNULLGROUPBYDWID)HONH.DW_ID=T.DW_IDLEFTOUTER(SELECTDW_ID,SUM(HCBDSJL)HCBDSJLFROM(SELECT WHERE A.RESULT_ID = R.RESULTS_ID(+) AND ISNOTNULLGROUPBYID, RESULT_ID,SCHEME_ID, DW_ID) ZGROUPBYDW_ID) LEF