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

LPX-00217: invalid character ~1u (~2x)

1 Answers  


ORA-12630: Native service operation not supported

1 Answers  


PROC-00017: Unimplemented feature

1 Answers  


PLS-01474: Use of ANY is non_ANSI

1 Answers  


SQL*Loader-00965: Error number disabling constraint string on table string

1 Answers  






ORA-39727: COMPATIBLE must be set to 10.0.0.0.0 or higher

1 Answers  


KUP-04016: unknown SLF status code number

1 Answers  


RMAN-06600: old RMAN configuration parameters:

1 Answers  


QSM-01092: mjv tries to rewrite a semi-join and primary key or rowid missing

1 Answers  


TNS-00551: underlying transport connection failed

1 Answers  


SQL*Loader-00703: Internal error: argument number

1 Answers  


ORA-38488: attribute set already assigned to the column storing expressions

1 Answers  


Categories