GROUP BY clause

Supported by ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

GROUP BY can be used to create unique groups of data, to form aggregations, to remove duplicates and for other reasons. It will transform your previously defined set of table expressions, and return only one record per unique group as specified in this clause.

Table of contents

3.5.3.5.1.

GROUP BY columns

3.5.3.5.2.

GROUP BY column index

3.5.3.5.3.

GROUP BY tables

3.5.3.5.4.

GROUP BY ROLLUP

3.5.3.5.5.

GROUP BY CUBE

3.5.3.5.6.

GROUP BY GROUPING SETS

3.5.3.5.7.

GROUP BY empty grouping set