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-10588: Can only allow 1 corruption for normal media/standby recovery

1 Answers  


ORA-25448: rule string.string has errors

1 Answers  


ORA-22977: missing or invalid attribute

1 Answers  


ORA-39317: illegal validation_check() call: only applys after clone/sync_code/valdation_check

1 Answers  


RMAN-07509: List of Cataloged Files

1 Answers  






ORA-38445: TOP clause not allowed with no statistics

1 Answers  


DRG-51201: failed to perform DDL operation: database object string

1 Answers  


ORA-24170: %s.string is created by AQ, cannot be dropped directly

1 Answers  


ORA-39502: failed to notify CRS of a Startup/Shutdown event [number] (ignored)

1 Answers  


ORA-38105: Delete not yet supported when Update row-migration is possible

1 Answers  


ORA-00447: fatal error in background process

1 Answers  


ORA-32626: illegal bounds or increment in MODEL FOR loop

1 Answers  


Categories