Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

TNS-03512: Used string adapter to resolve the alias

1 Answers  


ORA-39026: master table is inconsistent on validation string

1 Answers  


ORA-25142: default storage clause specified twice

1 Answers  


ORA-14064: Index with Unusable partition exists on unique/primary constraint key

1 Answers  


ORA-01530: a database already mounted by the instance

1 Answers  


ORA-00302: limit of string logs exceeded

1 Answers  


LPX-00656: XSLTVM terminate.

1 Answers  


NNC-00052: client and server protocol versions are incompatible

1 Answers  


ORA-07425: sdpri: error string in translating dump file location.

1 Answers  


ORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string)

1 Answers  


ORA-12063: unable to apply transaction from site string

1 Answers  


ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices

1 Answers  


Categories