1 2 3 4 5 6 7 8 9 10 11 | SELECT D.DEPT_NM_KOR, E.DEPT_CODE, E.EMP_NO, E.EMP_NM_KOR, E.JOB_CLS_CD, E.ENT_DD FROM HRMS.HDPB_EMP E, BASE.BDBS_DEPT D WHERE E.DEPT_CODE = D.DEPT_CODE AND E.DEPT_CODE IS NOT NULL ORDER BY E.DEPT_CODE, E.JOB_CLS_CD, E.ENT_DD |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | SELECT d.dept_nm_kor , e.dept_code , NVL(e.emp_no, COUNT (*)) emp_no , e.emp_nm_kor , e.job_cls_cd , e.ent_dd FROM hrms.hdpb_emp e , base.bdbs_dept d WHERE e.dept_code = d.dept_code AND e.dept_code IS NOT NULL GROUP BY e.dept_code, d.dept_nm_kor , ROLLUP ((e.job_cls_cd, e.ent_dd, e.emp_no, e.emp_nm_kor)) ORDER BY e.dept_code, e.job_cls_cd, e.ent_dd ; |