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

Home -> Community -> Usenet -> c.d.o.misc -> 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:47:37 -0800
Message-ID: <1167886056.917659.162870@q40g2000cwq.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:47:37 CST












Original text of this message













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