PLS-00118: Duplicate group-by clause in table expression

PLS-00118: Duplicate group-by clause in table expression
Cause: Two or more GROUP BY clauses were found in a SELECT statement. The GROUP BY clause lists column expressions used to form a summary row for each group of selected rows. The list can contain several column expressions separated by commas, but a statement can contain only one GROUP BY clause.
Action: Remove one of the GROUP BY clauses and, if necessary, separate column expressions by commas.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:01

PLS-00118：表表达式中的重复的group-by子句,
.原因：在SELECT语句中找到两个或多个GROUP BY子句。GROUP BY子句列出用于为每组所选行形成摘要行的列表达式。该列表可以包含逗号分隔的几个列表达式，但一个语句只能包含一个GROUP BY子句。,
.操作：删除其中一个GROUP BY子句，如有必要，可以使用逗号分隔列表达式。,
.

aiaiDBA

13718043309

010-86462881

PLS-00118: Duplicate group-by clause in table expression

1 个回答

相似问题