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

ORA-22629: OCIAnyData is null

1 Answers  


ORA-10614: Operation not allowed on this segment

1 Answers  


ORA-06562: type of out argument must match type of column or bind variable

1 Answers  


ORA-29530: could not create shortened name for string

1 Answers  


ORA-16206: database already configured as Logical Standby database

1 Answers  


NNL-00306: Server setting all statistic counters to zero

1 Answers  


KUP-04021: field formatting error for field string

1 Answers  


ORA-22131: hexadecimal string length is zero

1 Answers  


ORA-22330: cannot alter a type that is not valid

1 Answers  


ORA-13866: Client identifier must be specified

1 Answers  


ORA-02820: Unable to write the requested number of blocks

1 Answers  


ORA-02832: Segment deallocation failed - segment not on list

1 Answers  


Categories