ORACLE SUM OVER PARTITION (WITH CONDITION)




--------------------------------------------------------------------------------

SELECT LV, SUM(LV) OVER(PARTITION BY FLAG ORDER BY RN) SUMOVER
  FROM (SELECT ROWNUM RN, '99' AS FLAG, LEVEL LV
          FROM DUAL
        CONNECT BY LEVEL < 100
         ORDER BY 3)

Popular posts from this blog

youtube download

Image
https://www.youtube.com/watch?v=6jKqov6_zww ========================================================================= https:// ss youtube.com/watch?v=6jKqov6_zww http://www.clipconverter.cc/ http://en.savefrom.net/
Read more

com.gpki.secureweb.GPKISecureWEBException: ErrCode=1507,ErrMsg=[GPKI_CMS_ProcessEnvelopedData] 해당 인증서로는 데이터를 풀 수 없습니다.

om.gpki.secureweb.GPKISecureWEBException: ErrCode=1507,ErrMsg=[GPKI_CMS_ProcessEnvelopedData] 해당 인증서로는 데이터를 풀 수 없습니다. at com.gpki.servlet.GPKIHttpServletRequest.init(GPKIHttpServletRequest.java:550) at com.gpki.servlet.GPKIHttpServletRequest.<init>(GPKIHttpServletRequest.java:134) at kr.go.elevator.com.user.web.ComUserController.actionCrtfctLogin(ComUserController.java:485) at sun.reflect.GeneratedMethodAccessor1601.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.doInvokeMethod(HandlerMethodInvoker.java:421) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:136) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:326) at org.springfr
Read more

rexpert 공식필드(javascript) 점검일 주기 계산

점검일 주기계산으로 A,B,C,제외,초과,미점검 표시 rexpert 30 공식필드 CYCL         : 점검주기 3, 6, 12 LAST_DATE : 마지막 점검일 BC_DIV      : A, B, C, D(제외) BASE_BC_DIV : 기본 A -----------------------------------------------------------------------------------------------         var result; var cycle = rexpert.field("data.CYCL"); var lastDate = rexpert.field("data.LAST_DATE"); var bcDiv = rexpert.field("data.BC_DIV"); var baseBcDiv = rexpert.field("data.BASE_BC_DIV"); var today = new Date(); var nowMonth = (today.getMonth()+1)+""; var nowYear = today.getFullYear(); var lastYear = eval(lastDate.substring(0,4)); var lastMonth = eval(lastDate.substring(4,6)); var tMon=""; cycle = eval(cycle); if(cycle!=1){ //주기가 1개월이면 BASE_BC_DIV를 표시 if(lastDate !=null && lastDate != ""){ //마지막 점검일 체크 if(nowMonth < 10){ nowMonth="0"+nowMonth; } if(lastMonth+cycle>12){ lastYear =lastYear+1; tMon = (lastMonth+c
Read more