User Tools

Site Tools


kurs:rollup_und_cube

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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),​
kurs/rollup_und_cube.txt ยท Last modified: 2014/09/10 21:22 (external edit)