QSM-01061: illegal query expression



QSM-01061: illegal query expression..

Answer / guest

Cause: An illegal query was specified. Specifically one of
the following criteria was not satisfied: (a) All
(non-constant, non-aggregate) SELECT expressions in the
query should be made up of group expressions. (b) All column
references in the HAVING clause should come from the GROUP
BY expressions. (c) If there is an ORDER BY clause, then all
column references should come from the GROUP BY or SELECT
clause, depending on whether the query selects DISTINCT.

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

CLSR-00522: Resource string is not registered

1 Answers  


ORA-38484: FUNCTION/PACKAGE/TYPE string does not exist

1 Answers  


ORA-02402: PLAN_TABLE not found

1 Answers  


ORA-01243: system tablespace file suffered media failure

1 Answers  


ORA-31442: operation timed out while acquiring lock on string

1 Answers  






ORA-28513: internal error in heterogeneous remote agent

1 Answers  


NNL-00415: Name: string

1 Answers  


RMAN-08043: channel string: copy standby controlfile failed

1 Answers  


QSM-01012: SAMPLE clause present in FROM

1 Answers  


ORA-07266: sppst: invalid process number passed to sppst.

1 Answers  


ORA-27366: job "string.string" is not running

1 Answers  


ORA-25186: INCLUDING clause specified for index-organized table without OVERFLOW

1 Answers  


Categories