| |
- Causa
- THE GROUP BY CLAUSE CONTAINS element-1 NESTED WITHIN element-2.
The following types of nesting are not allowed within a GROUP BY clause:
- CUBE within CUBE, ROLLUP, or grouping-expression-list
- ROLLUP within CUBE, ROLLUP, or grouping-expression-list
- () - sometimes referred to a grand-total - within CUBE, ROLLUP, or grouping-expression-list
- GROUPING SETS within GROUPING SETS, CUBE, ROLLUP, or grouping-expression-list
- CUBE, ROLLUP, () - sometimes referred to a grand-total, GROUPING SETS within any function, CASE expression, or CAST specification
In some instances, the value *N will be provided for element-2.
In this case *N represents one of CUBE, ROLLUP, GROUPING SETS, or grouping-expression-list.
- Ação do sistema
- The statement cannot be processed.
- Resposta ao Desenvolvedor
- Modify the GROUP BY clause to remove the nesting identified by element-1.
SQLSTATE: 428B0
© Copyright IBM Corp.
|
| |
