aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

QSM-01060: illegal subquery in the HAVING clause

QSM-01060: illegal subquery in the HAVING clause
Cause: When a HAVING clause has a subquery, then any references to the tables in the outer query should only reference the tables in the GROUP BY clause.
Action: Correct error in the syntax and rerun the query.

请先 登录 后评论

1 个回答

小智
QSM-01060:HAVING子句中的非法子查询,
.原因:当HAVING子句具有子查询时,对外部查询中的表的任何引用应仅引用GROUP BY子句中的表。,
.操作:纠正语法错误并重新运行查询。,
.
请先 登录 后评论