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

NNL-00999: ALIAS LOOP responses received: number

1 Answers  


DRG-11121: failed to read from file string

1 Answers  


TNS-00028: INTCTL: Could not resolve Connection Manager's name/address

1 Answers  


ORA-36976: (XSRELGID00) The format of the GROUPINGID command is: GROUPINGID [relation1] INTO {variable | relation2 | surrogate} [USING levelrelation] [INHIERARCHY {inhvariable | valueset}] [LEVELORDER levelordervs] The source relation can be omitted only when using both surrogate gid and level order valueset.

1 Answers  


TNS-00071: where <command> is one of following:

1 Answers  






TNS-00512: Address already in use

1 Answers  


O2F-00301: Error attempting to read from the INTYPE file

1 Answers  


NNO-00056: warning: domain minimum TTL must be between number and number, set to number seconds

1 Answers  


ORA-00322: log string of thread string is not current copy

1 Answers   Sabro,


ORA-00065: initialization of FIXED_DATE failed

1 Answers  


ORA-14095: ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table

1 Answers  


ORA-32139: Cannot write to the stream

1 Answers  


Categories