Differences

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

--- kurs:rollup_und_cube [2010/10/30 13:04]
mh
+++ kurs:rollup_und_cube [2010/10/30 13:11]
mh
@@ Line 12: / Line 12: @@
 </code>
+<code>
+  SELECT grouping(DEPARTMENT_NAME),
+                  DEPARTMENT_NAME,
+         grouping(COUNTRY_NAME),
+                  COUNTRY_NAME,
+                  (count(EMPLOYEES.EMPLOYEE_ID)) c
+      FROM DEPARTMENTS , LOCATIONS , COUNTRIES , EMPLOYEES
+  WHERE ( (LOCATIONS.LOCATION_ID = DEPARTMENTS.LOCATION_ID) AND
+          (COUNTRIES.COUNTRY_ID = LOCATIONS.COUNTRY_ID) AND
+          (DEPARTMENTS.DEPARTMENT_ID = EMPLOYEES.DEPARTMENT_ID) )
+   group by cube (COUNTRIES.COUNTRY_NAME, DEPARTMENTS.DEPARTMENT_NAME  )
+minus
+  SELECT grouping(DEPARTMENT_NAME),
+                  DEPARTMENT_NAME,
+         grouping(COUNTRY_NAME),
+                  COUNTRY_NAME,
+                  (count(EMPLOYEES.EMPLOYEE_ID)) c
+      FROM DEPARTMENTS , LOCATIONS , COUNTRIES , EMPLOYEES
+  WHERE ( (LOCATIONS.LOCATION_ID = DEPARTMENTS.LOCATION_ID) AND
+          (COUNTRIES.COUNTRY_ID = LOCATIONS.COUNTRY_ID) AND
+          (DEPARTMENTS.DEPARTMENT_ID = EMPLOYEES.DEPARTMENT_ID) )
+   group by rollup (COUNTRIES.COUNTRY_NAME, DEPARTMENTS.DEPARTMENT_NAME,   )
+</code>
 <code>

dokuwiki