[每日一题]OCP1z0-047 :2013-08-20 GROUP BY扩展??GROUPING、ROLLUP(二)
tal,
26 1 GRP_DEPT,
27 1 GRP_JOB,
28 1 GRP_LOC
29 FROM employees e JOIN departments d
30 ON e.department_id=d.department_id
31 order by 1,2;
DEPARTMENT_ID JOB_ID LOCATION_ID TOTAL GRP_DEPT GRP_JOB GRP_LOC
------------- ---------- ----------- ---------- ---------- ---------- ----------
10 AD_ASST 1700 4400 0 0 0
10 AD_ASST 4400 0 0 1
10 4400 0 1 1
20 MK_MAN 1800 13000 0 0 0
20 MK_MAN 13000 0 0 1
20 MK_REP 6000 0 0 1
20 MK_REP 1800 6000 0 0 0
20 19000 0 1 1
30 PU_CLERK 1700 13900 0 0 0
30 PU_CLERK 13900 0 0 1
30 PU_MAN 11000 0 0 1
30 PU_MAN 1700 11000 0 0 0
30 24900 0 1 1
40 HR_REP 6500 0 0 1
40 HR_REP 2400 6500 0 0 0
40 6500 0 1 1
50 SH_CLERK 64300 0 0 1
50 SH_CLERK 1500 64300 0 0 0
50 ST_CLERK 55700 0 0 1
50 ST_CLERK 1500 55700 0 0 0
50 ST_MAN 1500 36400 0 0 0
50 ST_MAN 36400 0 0 1
50 156400 0 1 1
60 IT_PROG 1400 28800 0 0 0
60 IT_PROG 28800 0 0 1
60 28800 0 1 1
70 PR_REP 2700 10000 0 0 0
70 PR_REP 10000 0 0 1
70 10000 0 1 1
80 SA_MAN 2500 61000 0 0 0
80 SA_MAN 61000 0 0 1
80 SA_REP 2500 243500 0 0 0
80 SA_REP 243500 0 0 1
80 304500 0 1 1
90 AD_PRES 24000 0 0 1
90 AD_PRES 1700 24000 0 0 0
90 AD_VP 1700 34000 0 0 0
90 AD_VP 34000 0 0 1
90 58000 0 1 1
100 FI_ACCOUNT 39600 0 0 1
100 FI_ACCOUNT 1700 39600 0 0 0
100 FI_MGR 1700 12008 0 0 0
100 FI_MGR 12008 0 0 1
100 51608 0 1 1
110 AC_ACCOUNT 1700 8300 0 0 0
110 AC_ACCOUNT 8300 0 0 1
110 AC_MGR 1700 12008 0 0 0
110 AC_MGR 12008 0 0 1
110 20308 0 1 1
684416 1 1 1
50 rows selected.