SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE dimension_tab ( Location NUMBER NOT NULL, Product NUMBER NOT NULL, Employee NUMBER NOT NULL, sales_value NUMBER(10,2) NOT NULL ); INSERT INTO dimension_tab SELECT TRUNC(DBMS_RANDOM.value(low => 1, high => 3)) AS Location, TRUNC(DBMS_RANDOM.value(low => 1, high => 15)) AS Product, TRUNC(DBMS_RANDOM.value(low => 1, high => 11)) AS Employee, ROUND(DBMS_RANDOM.value(low => 1, high => 100), 2) AS sales_value FROM dual CONNECT BY level <= 1000; SELECT Location, Product, Employee, SUM(sales_value) AS sales_value FROM dimension_tab GROUP BY CUBE (Location, Product, Employee) ORDER BY Location, Product, Employee; SELECT Location, Product, Employee, SUM(sales_value) AS sales_value FROM dimension_tab GROUP BY Location, CUBE (Product, Employee) ORDER BY Location, Product, Employee;