Skip to content

Group By

Jump to bottom
agershun edited this page Dec 28, 2014 · 7 revisions

SELECT GROUP BY

Grouping

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

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