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

NNO-00256: using administrative region "string"

1 Answers  


ORA-12531: TNS:cannot allocate memory

1 Answers  


ORA-13771: cannot obtain exclusive lock string on "SQL Tuning Set" "string"

1 Answers  


RMAN-06751: ASM file string cannot be proxy backed up.

1 Answers  


LPX-00220: the string "]]>" cannot occur in character data

1 Answers  






NNL-00007: server responded with an error

1 Answers  


ORA-25210: invalid value for RELATIVE_MSGID, no message in queue with that msgid

1 Answers  


PLS-00162: Pragma string expects 4th argument to be a positive integer literal

1 Answers  


ORA-38765: Flashed back database cannot be opened read-only.

1 Answers  


ORA-02182: savepoint name expected

1 Answers  


QSM-01073: materialized view, string, has a join not found in query

1 Answers  


TNS-00022: INTCTL: missing CMANAGER_NAME in INTCHG.ORA

1 Answers  


Categories