Skip to content

Group By

Jump to bottom
agershun edited this page Jan 10, 2015 · 7 revisions

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)');

© 2014-2024, Andrey Gershun & Mathias Rangel Wulff

Please help improve the documentation by opening a PR on the wiki repo

Quick links

Clone this wiki locally