Group By

SELECT GROUP BY

Grouping by columns:

    var res = alasql('SELECT * FROM City GROUP BY Contient, Country');

Grouping by expressions:

    var res = alasql('SELECT b FROM Nums GROUP BY a%2');

Grouping functions

• CUBE()
• ROLLUP()
• GROUPING SETS()

    alasql('SELECT * FROM City GROUP BY ROLLUP(Continent, Country)');

See jsFiddle example for ROLLUP(), CUBE(), and GROUPING SETS().