GROUP BY Clause#

Syntax#

GroupByClause
         ::= 'GROUP' 'BY' ByList

SQL Statement Template#

SELECT select_expr [,select_expr...] FROM ... GROUP BY ...

Description#

For the standalone version, GROUP BY is supported in all conditions. For the cluster version, the execution modes which support this clause are shown below.

SELECT Statement Elements

Offline Mode

Online Preview Mode

Online Request Mode

Note

GROUP BY Clause

✓

The Group By clause is used to group the query results.The grouping conditions only support grouping on simple columns.

Example#

1. Aggregate After Grouping By One Column

SELECT COL1, SUM(COL2), AVG(COL2) FROM t1 group by COL1;

2. Aggregate After Grouping By Two Columns

SELECT COL1, SUM(COL2), AVG(COL2) FROM t1 group by COL1, COL0;