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

O2F-00341: An error occurred for which no message is available

1 Answers  


ORA-22370: incorrect usage of method string

1 Answers  


PLS-00483: exception 'string' may appear in at most one exception handler in this block

1 Answers  


ORA-01350: must specify a tablespace name

1 Answers  


SQL*Loader-00529: OCI return status: invalid handle

1 Answers  






ORA-23456: flavor string does not contain "string"

1 Answers  


ORA-28662: IOT index and overflow segments must share the same LOGGING attribute

1 Answers  


RMAN-06225: shuting down automatic instance string

1 Answers  


ORA-01936: cannot specify owner when creating users or roles

1 Answers  


ORA-25470: duplicate attribute value for variable: string

1 Answers  


EXP-00072: error closing export file string

1 Answers  


ORA-02246: missing EVENTS text

1 Answers  


Categories