PLS-00119: Duplicate having-clause in table expression

PLS-00119: Duplicate having-clause in table expression
Cause: Two or more HAVING clauses were found in a SELECT statement. The HAVING clause specifies a condition under which groups of rows (formed by the GROUP BY clause) are included in the result. The condition can include several logical expressions connected by AND or OR, but a statement can contain only one HAVING clause.
Action: Remove one of the HAVING clauses and, if necessary, connect logical expressions by AND or OR.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:01

PLS-00119：表表达式中的重复的有子句,
.原因：在SELECT语句中找到两个或多个HAVING子句。HAVING子句指定一个条件，在该条件下，结果中包含一组行（由GROUP BY子句组成）。条件可以包括由AND或OR连接的多个逻辑表达式，但是一个语句只能包含一个HAVING子句。,
.操作：删除其中一个HAVING子句，如有必要，用AND或OR连接逻辑表达式。,
.

aiaiDBA

13718043309

010-86462881

PLS-00119: Duplicate having-clause in table expression

1 个回答

相似问题