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-26026: unique index string.string initially in unusable state

0 Answers   Forbis, VC,


ORA-19729: File string is not the initial version of the plugged in datafile

1 Answers  


SQL*Loader-00471: OID or SID clause has an argument that is CONSTANT

1 Answers  


ORA-19605: input filename must be specified

1 Answers  


TNS-01024: Trace Level string

1 Answers  






ORA-02726: osnpop: access error on oracle executable

1 Answers  


ORA-07822: sspscm: SYS$CREMBX failure

1 Answers  


DRG-11517: error when validating text objects

1 Answers  


ORA-32014: error processing parameter "string" from the SPFILE restore image

1 Answers  


ORA-32037: unsupported use of LEVEL in membership condition

1 Answers  


NNO-00612: enabling request forwarding

1 Answers  


ORA-00337: log file 'string' does not exist and no size specified

1 Answers  


Categories