A simple GROUP BY clause does not contain any of the following elements:
- rollup_list
- cube_list
- grouping_sets_specification
A primitive GROUP BY clause does not contain any of the following elements:
- rollup_list
- cube_list
- grouping_sets_specification
- grouping_expression and empty_grouping_set
See GROUPING SETS Option for definitions of rollup_list, cube_list, grouping_sets_specification, and empty_grouping_set.
See the following topics for examples of non-simple, non-primitive GROUP BY clauses: