구체적으로 적어주세요.

어떤 테이블에 어떤 컬럼이 필요한지?, 조인 키는 뭔지?

WITH t1 (날짜, 번호, 출력순서, 금액구분, 금액) AS
(
          SELECT '2016/01/02', 1, 1, 'A', 10000 FROM dual
UNION ALL SELECT '2016/01/02', 1, 2, 'B', 10000 FROM dual
UNION ALL SELECT '2016/01/11', 2, 1, 'A', 20000 FROM dual
UNION ALL SELECT '2016/02/22', 3, 1, 'A', 10000 FROM dual
UNION ALL SELECT '2016/02/23', 4, 1, 'B', 20000 FROM dual
)
, t2 (번호, dept_cd, emp_cd) AS
(
          SELECT 1, 11, 111 FROM dual
UNION ALL SELECT 2, 22, 222 FROM dual
UNION ALL SELECT 3, 33, 333 FROM dual
UNION ALL SELECT 4, 44, 444 FROM dual
)
SELECT SUBSTR(t1.날짜, 1, 7) 년월
     , NVL(t1.날짜, '누계') 날짜
     , t1.번호
     , t1.출력순서
     , t2.dept_cd
     , t2.emp_cd
     , SUM(DECODE(금액구분, 'A', 금액)) 금액a
     , SUM(DECODE(금액구분, 'B', 금액)) 금액b
  FROM t1
     , t2
 WHERE t1.번호 = t2.번호
 GROUP BY SUBSTR(t1.날짜, 1, 7)
     , ROLLUP((t1.날짜, t1.번호, t1.출력순서, t2.dept_cd, t2.emp_cd))
;