삭제 0 4 1,205

by Oracle10g [SQL Query] [2017.12.15 09:42:05]


삭제
by 우리집아찌 [2017.12.15 10:12:21]

왜 22일에서 44로 되나요?


by 우리집아찌 [2017.12.15 10:37:20]

아 잘못봤네.. ㅎㅎ


by 랑에1 [2017.12.15 10:16:14]
SELECT empno, trainymd, SUM(duttm) OVER(PARTITION BY empno, gb ORDER BY trainymd) AS amt
FROM 
(
  SELECT T.*, SUM(DECODE(hcnt, 12, 1, 0)) OVER(PARTITION BY empno ORDER BY trainymd) gb
  FROM T
)

 


by 고수가되고싶어요 [2017.12.15 10:22:36]
WITH T AS (
SELECT '216990'   EMPNO
     , '20171211' TRAINYMD
     , 0          HCNT
     , 22         DUTTM FROM DUAL UNION ALL
SELECT '216990' , '20171212' , 0   , 22 FROM DUAL UNION ALL
SELECT '216990' , '20171213' , 0   , 11 FROM DUAL UNION ALL
SELECT '216990' , '20171214' , 12  , 21 FROM DUAL UNION ALL
SELECT '216990' , '20171215' , 0   , 22 FROM DUAL UNION ALL
SELECT '216990' , '20171216' , 0   , 22 FROM DUAL UNION ALL
SELECT '216990' , '20171217' , 0   , 22 FROM DUAL UNION ALL
SELECT '216990' , '20171218' , 0   , 11 FROM DUAL UNION ALL
SELECT '216990' , '20171219' , 12  , 11 FROM DUAL UNION ALL
SELECT '216990' , '20171220' , 12  , 22 FROM DUAL UNION ALL
SELECT '216990' , '20171221' , 0   , 22 FROM DUAL UNION ALL
SELECT '216990' , '20171222' , 0   , 22 FROM DUAL UNION ALL
SELECT '216990' , '20171223' , 0   , 22 FROM DUAL UNION ALL
SELECT '216990' , '20171224' , 0   , 22 FROM DUAL 
)
SELECT trainymd
	  ,SUM(duttm) OVER(PARTITION BY gb ORDER BY trainymd) 
FROM(
SELECT trainymd
	  ,duttm 
	  ,SUM(hcnt) over(PARTITION BY empno ORDER BY trainymd) gb  
FROM t )

 

댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.
로그인 사용자만 댓글을 작성 할 수 있습니다. 로그인, 회원가입