Oracle SQL I cannot do group by

Question

The error I'm getting is Missing Expression

Below is my SQL statement

select 
ecell_name, 
ecell_relation,
pmm_datetime,

pmHoExeOutAttLteInterFQci1 As_Exec_Attempt_Out
--pmHoExeOutSuccLteInterFQci1 As_Exec_Succes_Out, 
--(pmHoTooEarlyHoQci1) As Early_HO, (pmHoTooLateHoQci1)  As Late_HO, 
--(pmHoWrongCellReestQci1) As WrongCellReest_HO, 
--(pmHoWrongCellQci1) As WrongCell_HO, (pmHoOscQci1) As Osc_HO

from PMMCOUNTER_DB.LC_N_EUTRANCELLREL_D

where substr (ECELL_NAME,1,4) in 'BKPA' and pmm_datetime BETWEEN TO_DATE('14/06/2019','DD/MM/YYYY') AND TO_DATE('15/06/2019','DD/MM/YYYY') and direction='Outgoing' 
and GROUP BY ecell_relation

GROUP BY should come after the WHERE clause and shouldn't be a part of it — MJoy
– MJoy, Commented Jun 26, 2019 at 3:48
For a question here is better if you rename some columns in order to make the question more understandable. Reviewing your query, it seems to have an extra "and" before the GROUP BY — dubafek
– dubafek, Commented Jun 26, 2019 at 4:17

Ivan Ivanov · Accepted Answer · 2019-06-26 03:46:29Z

1

First, you need to delete and orepator before your group by. Second, you need to use all selected fields in your group by. This should works:

 select ecell_name,
       ecell_relation,
       pmm_datetime,

       pmHoExeOutAttLteInterFQci1 As_Exec_Attempt_Out
--pmHoExeOutSuccLteInterFQci1 As_Exec_Succes_Out, 
--(pmHoTooEarlyHoQci1) As Early_HO, (pmHoTooLateHoQci1)  As Late_HO, 
--(pmHoWrongCellReestQci1) As WrongCellReest_HO, 
--(pmHoWrongCellQci1) As WrongCell_HO, (pmHoOscQci1) As Osc_HO

  from PMMCOUNTER_DB.LC_N_EUTRANCELLREL_D

 where substr(ECELL_NAME, 1, 4) in 'BKPA'
   and pmm_datetime BETWEEN TO_DATE('14/06/2019', 'DD/MM/YYYY') AND
       TO_DATE('15/06/2019', 'DD/MM/YYYY')
   and direction = 'Outgoing' 
 GROUP BY ecell_relation, ecell_name, pmm_datetime, pmHoExeOutAttLteInterFQci1

answered Jun 26, 2019 at 3:46

Ivan Ivanov

5352 gold badges5 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user11700617 Over a year ago

It worked. Thank you for explaining it and correcting it.

sandi · Accepted Answer · 2019-06-26 03:39:07Z

0

delete operator "and" before GROUP BY

answered Jun 26, 2019 at 3:39

sandi

112 bronze badges

Collectives™ on Stack Overflow

Oracle SQL I cannot do group by

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related