Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00979 : not a GROUP BY expression
ORA-00979 : not a GROUP BY expression [message #343] Wed, 06 February 2002 05:20 Go to next message
sorcer
Messages: 19
Registered: January 2002
Junior Member
Hello,
I have the error ORA-00979 : not a GROUP BY expression, when i try to execute this request :

SELECT T.A_RO, A.A_ANCIEN_RO, T.A_NOM, T.A_PRENOM, I.N_NUM_SEQ AS N_NUM_SEQ_INF, T.N_NUM_SEQ AS N_NUM_SEQ_TIERS, I.A_NUM_PV, TO_CHAR(I.D_DATE_HEURE, 'DD/MM/YYYY')"D_DATE_HEURE", I.A_SERVICE_VERB, I.A_CODE_NATINF
FROM ...
WHERE ...
GROUP BY T.A_RO

I think you don't need the FROM and WHERE clauses (i hope).

Thank you very much.
Re: ORA-00979 : not a GROUP BY expression [message #344 is a reply to message #343] Wed, 06 February 2002 05:57 Go to previous message
Scott Ames
Messages: 1
Registered: February 2002
Junior Member
The Group By functionality seems to want you to mirror the items in the Select statement. If you put every field in the Group By that you put in the Select it might work.
Previous Topic: call procedure/function from web-page
Next Topic: ORA- 205 Can not mount database per.ora8 in win98
Goto Forum:
  


Current Time: Thu Mar 28 14:19:08 CDT 2024