How to resolve ORA-00979 not a GROUP BY expression [closed]

I am getting ORA-00979 with the following query:

select Unit , count(samid_rfpid) ,  (tcv+tcv_euro) as total from Closerfprfx GROUP BY Unit

​x
 
select Unit , count(samid_rfpid) ,  (tcv+tcv_euro) as total from Closerfprfx GROUP BY Unit​

je veux voir tous les nuits sans doublons , avec un total de leur tcv et tcv_euro ainsi que le nombre sam_rfpid quand j’ajoute tcv_euro et tcv dans groupe by j’ai pas le bon affichage :

 Unit count total
  CCF   1     500
CCF   1     500
CCF   1     500
CCF   1     500
CCF   1     500

 
 Unit count total  CCF   1     500CCF   1     500CCF   1     500CCF   1     500CCF   1     500​

the correct display :

Unit  count    total
CCF   5            56140

 
Unit  count    totalCCF   5            56140​

please what i should to do to resolve this error

Answer

You need to use aggregate function:

SELECT UNIT,
       COUNT(SAMID_RFPID),
       SUM(TCV + TCV_EURO) AS TOTAL -- here
  FROM CLOSERFPRFX
 GROUP BY UNIT

 
SELECT UNIT,       COUNT(SAMID_RFPID),       SUM(TCV + TCV_EURO) AS TOTAL -- here  FROM CLOSERFPRFX GROUP BY UNIT​

Advertisement

Answer