This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
kurs:rollup_und_cube [2010/10/30 13:11] mh |
kurs:rollup_und_cube [2011/05/31 12:57] mh |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code> | ||
+ | select department_name, jj, sum(salary) from ( | ||
+ | select department_name, | ||
+ | regexp_replace(job_id, '^[[:alpha:]]{2}_', '') jj, | ||
+ | salary from employees e, departments d | ||
+ | where e.department_id = d.department_id | ||
+ | ) | ||
+ | group by cube (department_name, jj) | ||
+ | </code> | ||
+ | |||
+ | |||
<code> | <code> | ||
SELECT grouping(DEPARTMENT_NAME), | SELECT grouping(DEPARTMENT_NAME), |