Hibernate: SELECT TO_CHAR(RSJ.RQ,'YYYY-MM') SJSJ, SUM(DECODE(RSJ.SJBH, '9010', TO_NUMBER(RSJ.PJZ), NULL)) AS V9010 FROM TJ_RSJ RSJ, ZC_ZDZC ZD, YH_YH YH WHERE RSJ.ZDLJDZ = ZD.ZDLJDZ AND ZD.YHID = YH.YHID AND RSJ.SJBH ='9010' AND TO_CHAR(TRUNC(RSJ.RQ, 'mm'), 'yyyy') = '2006' AND YH.SDRL > 500 AND YH.SDRL <= 40000 AND YH.GDDY IN ( '380V电压' , '100V电压' ) AND YH.HYID IN (SELECT T.HYID FROM YH_HY T START WITH T.HYID = '430010' CONNECT BY PRIOR T.HYID = T.SJHYID AND T.HYID != T.SJHYID) AND YH.GDXLID IN (SELECT X.JDID FROM YH_DW X START WITH X.JDID = '470001' CONNECT BY PRIOR X.JDID = X.SJJDID AND X.JDID != X.SJJDID) group by TO_CHAR(RSJ.RQ,'YYYY-MM') order by TO_CHAR(RSJ.RQ,'YYYY-MM')
Hibernate: SELECT TO_CHAR(RSJ.RQ,'YYYY-MM') SJSJ, SUM(DECODE(RSJ.SJBH, '9010', TO_NUMBER(RSJ.PJZ), NULL)) AS V9010 FROM TJ_RSJ RSJ, ZC_ZDZC ZD, YH_YH YH WHERE RSJ.ZDLJDZ = ZD.ZDLJDZ AND ZD.YHID = YH.YHID AND RSJ.SJBH ='9010' AND TO_CHAR(TRUNC(RSJ.RQ, 'mm'), 'yyyy') = '2005' AND YH.SDRL > 500 AND YH.SDRL <= 40000 AND YH.GDDY IN ( '380V电压' , '100V电压' ) AND YH.HYID IN (SELECT T.HYID FROM YH_HY T START WITH T.HYID = '430010' CONNECT BY PRIOR T.HYID = T.SJHYID AND T.HYID != T.SJHYID) AND YH.GDXLID IN (SELECT X.JDID FROM YH_DW X START WITH X.JDID = '470001' CONNECT BY PRIOR X.JDID = X.SJJDID AND X.JDID != X.SJJDID) group by TO_CHAR(RSJ.RQ,'YYYY-MM') order by TO_CHAR(RSJ.RQ,'YYYY-MM')
OKYear
2
12
Hibernate: SELECT TO_CHAR(RSJ.RQ,'YYYY-MM-DD') SJSJ, SUM(DECODE(RSJ.SJBH, '9010', TO_NUMBER(RSJ.PJZ), NULL)) AS V9010 FROM TJ_RSJ RSJ, ZC_ZDZC ZD, YH_YH YH WHERE RSJ.ZDLJDZ = ZD.ZDLJDZ AND ZD.YHID = YH.YHID AND RSJ.SJBH ='9010' AND TO_CHAR(TRUNC(RSJ.RQ, 'mm'), 'yyyy-mm') = '2006-01' AND YH.SDRL > 500 AND YH.SDRL <= 40000 AND YH.GDDY IN ( '380V电压' , '100V电压' ) AND YH.HYID IN (SELECT T.HYID FROM YH_HY T START WITH T.HYID = '430010' CONNECT BY PRIOR T.HYID = T.SJHYID AND T.HYID != T.SJHYID) AND YH.GDXLID IN (SELECT X.JDID FROM YH_DW X START WITH X.JDID = '470001' CONNECT BY PRIOR X.JDID = X.SJJDID AND X.JDID != X.SJJDID) GROUP BY TO_CHAR(RSJ.RQ,'YYYY-MM-DD') ORDER BY TO_CHAR(RSJ.RQ,'YYYY-MM-DD')
Hibernate: SELECT TO_CHAR(RSJ.RQ,'YYYY-MM-DD') SJSJ, SUM(DECODE(RSJ.SJBH, '9010', TO_NUMBER(RSJ.PJZ), NULL)) AS V9010 FROM TJ_RSJ RSJ, ZC_ZDZC ZD, YH_YH YH WHERE RSJ.ZDLJDZ = ZD.ZDLJDZ AND ZD.YHID = YH.YHID AND RSJ.SJBH ='9010' AND TO_CHAR(TRUNC(RSJ.RQ, 'mm'), 'yyyy-mm') = '2005-02' AND YH.SDRL > 500 AND YH.SDRL <= 40000 AND YH.GDDY IN ( '380V电压' , '100V电压' ) AND YH.HYID IN (SELECT T.HYID FROM YH_HY T START WITH T.HYID = '430010' CONNECT BY PRIOR T.HYID = T.SJHYID AND T.HYID != T.SJHYID) AND YH.GDXLID IN (SELECT X.JDID FROM YH_DW X START WITH X.JDID = '470001' CONNECT BY PRIOR X.JDID = X.SJJDID AND X.JDID != X.SJJDID) GROUP BY TO_CHAR(RSJ.RQ,'YYYY-MM-DD') ORDER BY TO_CHAR(RSJ.RQ,'YYYY-MM-DD')
OKMonth
2
28
Hibernate: SELECT TO_CHAR(RSJ.RQ,'YYYY-MM-DD') SJSJ, SUM(DECODE(RSJ.SJBH, '9010', TO_NUMBER(RSJ.PJZ), NULL)) AS V9010 FROM TJ_RSJ RSJ, ZC_ZDZC ZD, YH_YH YH WHERE RSJ.ZDLJDZ = ZD.ZDLJDZ AND ZD.YHID = YH.YHID AND RSJ.SJBH ='9010' AND RSJ.RQ BETWEEN TO_DATE('2006-04-02', 'yyyy-mm-dd') AND TO_DATE('2006-04-16', 'yyyy-mm-dd') AND YH.SDRL > 500 AND YH.SDRL <= 40000 AND YH.GDDY IN ( '380V电压' , '100V电压' ) AND YH.HYID IN (SELECT T.HYID FROM YH_HY T START WITH T.HYID = '430010' CONNECT BY PRIOR T.HYID = T.SJHYID AND T.HYID != T.SJHYID) AND YH.GDXLID IN (SELECT X.JDID FROM YH_DW X START WITH X.JDID = '470001' CONNECT BY PRIOR X.JDID = X.SJJDID AND X.JDID != X.SJJDID) GROUP BY TO_CHAR(RSJ.RQ,'YYYY-MM-DD') ORDER BY TO_CHAR(RSJ.RQ,'YYYY-MM-DD')
Hibernate: SELECT TO_CHAR(RSJ.RQ,'YYYY-MM-DD') SJSJ, SUM(DECODE(RSJ.SJBH, '9010', TO_NUMBER(RSJ.PJZ), NULL)) AS V9010 FROM TJ_RSJ RSJ, ZC_ZDZC ZD, YH_YH YH WHERE RSJ.ZDLJDZ = ZD.ZDLJDZ AND ZD.YHID = YH.YHID AND RSJ.SJBH ='9010' AND RSJ.RQ BETWEEN TO_DATE('2006-04-02', 'yyyy-mm-dd') AND TO_DATE('2006-04-16', 'yyyy-mm-dd') AND YH.SDRL > 500 AND YH.SDRL <= 40000 AND YH.GDDY IN ( '380V电压' , '100V电压' ) AND YH.HYID IN (SELECT T.HYID FROM YH_HY T START WITH T.HYID = '430010' CONNECT BY PRIOR T.HYID = T.SJHYID AND T.HYID != T.SJHYID) AND YH.GDXLID IN (SELECT X.JDID FROM YH_DW X START WITH X.JDID = '470001' CONNECT BY PRIOR X.JDID = X.SJJDID AND X.JDID != X.SJJDID) GROUP BY TO_CHAR(RSJ.RQ,'YYYY-MM-DD') ORDER BY TO_CHAR(RSJ.RQ,'YYYY-MM-DD')
OKWeek
2
7