QSM-01060: illegal subquery in the HAVING clause



QSM-01060: illegal subquery in the HAVING clause..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06419: NETCMN: server can not start oracle

1 Answers  


SQL*Loader-00954: Error shipping index to read buffer across 2-task

1 Answers  


DRG-11519: encounter error when exporting a LONG or LONG RAW column

1 Answers  


ORA-32742: Hang analysis initialize failed

1 Answers  


TNS-01181: Internal registration connection limit reached

1 Answers  






QSM-02185: no partition key or PMARKER in select list

1 Answers  


KUP-04013: other system error

1 Answers  


ORA-19038: Invalid opertions on query context

1 Answers  


ORA-30344: number of child cols different from number of parent level cols

1 Answers  


ORA-16739: log transport service for standby "string" unexpectedly online

1 Answers  


LSX-00014: empty instance document

1 Answers  


NZE-29106: Cannot import PKCS #12 wallet.

1 Answers  


Categories