Databases Reference
In-Depth Information
AD_PRES 24000
IT_PROG 5760
PU_CLERK 2780
SH_CLERK 3215
ST_CLERK 2785
10 4400
10 AD_ASST 4400
20 9500
20 MK_MAN 13000
20 MK_REP 6000
30 4150
30 PU_MAN 11000
30 PU_CLERK 2780
40 6500
40 HR_REP 6500
50 3475.55556
50 ST_MAN 7280
50 SH_CLERK 3215
50 ST_CLERK 2785
60 5760
60 IT_PROG 5760
70 10000
70 PR_REP 10000
80 8955.88235
80 SA_MAN 12200
80 SA_REP 8396.55172
90 19333.3333
90 AD_VP 17000
90 AD_PRES 24000
40 rows selected.
Using CUBE, she has two columns listed in our ROLLUP clause and therefore
will have four (two squared) types of groupings in the query output:
◆
Combinations of departments and jobs (for example, 30 and PU_CLERK,
with an average salary of 2780)
Summaries by jobs (for example, MK_REP having an average salary of 6000)
◆
Summaries by departments (for example, 20 and a NULL job title, with an
average salary of 9500)
◆
A grand total (NULL department number and NULL job title, with an
average salary for all employees in all departments of 6250)
◆
