Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-00979: not a GROUP BY expression - can someone help?

ORA-00979: not a GROUP BY expression - can someone help?

From: Mohd Al Junaibi <mohamed.aljunaibi_at_gmail.com>
Date: 3 Jan 2007 20:13:18 -0800
Message-ID: <1167883998.424314.68070@31g2000cwt.googlegroups.com> 






Hello all,



 I'm receiving a ORA-00979 (NOT A GROUP BY Expression) error when I try
to run the below statement:




SELECT   APPLICATIONAUTH.APP, APPLICATIONAUTH.GROUPNAME,


 ( sum(decode(optionname,'READ',1,'INSERT',3,'DELETE',5,'SAVE',7) ) )
As authCalc,



MAXAPPS.DESCRIPTION



FROM     APPLICATIONAUTH, MAXAPPS



WHERE    APPLICATIONAUTH.APP = MAXAPPS.APP

GROUP BY APPLICATIONAUTH.APP, APPLICATIONAUTH.GROUPNAME


 Can someone help me? I'm new to Oracle, and I think it is a silly
mistake.
Received on Wed Jan 03 2007 - 22:13:18 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US