Skip to content

Latest commit

 

History

History
18 lines (14 loc) · 629 Bytes

Cube.md

File metadata and controls

18 lines (14 loc) · 629 Bytes
Raw

Keyword CUBE

AlaSQL supports CUBE() grouping options:

var testData = [
    { Phase: "Phase 1", Step: "Step 1", Task: "Task 1", Val: 5 },
    { Phase: "Phase 1", Step: "Step 2", Task: "Task 2", Val: 20 },
    { Phase: "Phase 2", Step: "Step 1", Task: "Task 1", Val: 25 },
    { Phase: "Phase 2", Step: "Step 2", Task: "Task 2", Val: 40 }
];

res = alasql('SELECT Phase, Step, SUM(Val) AS Val FROM ? \
                  GROUP BY CUBE(Phase,Step)', [testData]);

Try this example in jsFiddle

See also: ROLLUP, [GROUPING SETS](Grouping Sets), [GROUP BY](Group By)