Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error ORA-00937: not a single-group group function

485923Jan 26 2006 — edited Jan 26 2006
I have the following script:

SELECT ar.ruta,dto.descripcion Departamento,mun.descripcion Municipio,
SUM(DECODE(ar.diavisita,'1',COUNT(ar.no_cliente),0))lunes,
SUM(DECODE(ar.diavisita,'2',COUNT(ar.no_cliente),0))Martes,
SUM(DECODE(ar.diavisita,'3',COUNT(ar.no_cliente),0))Miercoles,
SUM(DECODE(ar.diavisita,'4',COUNT(ar.no_cliente),0))Jueves,
SUM(DECODE(ar.diavisita,'5',COUNT(ar.no_cliente),0))Viernes,
SUM(DECODE(ar.diavisita,'6',COUNT(ar.no_cliente),0))Sabado
FROM arccar ar, arccpro dto, arcccan mun, arccmc mc
WHERE (mc.no_cia = ar.no_cia
AND mc.centro = ar.centro
AND mc.grupo = ar.grupo
AND mc.no_cliente = ar.no_cliente)
AND (dto.pais = mc.pais
AND dto.zona = mc.zona
AND dto.provincia = mc.provincia)
AND (mun.pais(+) = mc.pais
AND mun.provincia(+) = mc.provincia
AND mun.canton(+) = mc.canton)
AND mc.activo = 'S'
AND ar.ruta = '311'
AND ar.semana = '2'
GROUP BY ar.ruta,dto.descripcion,mun.descripcion,ar.diavisita

...when I execute the query in PL/SQL Developer I get this error, Error ORA-00937: not a single-group group function.

Can somebody help me.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 23 2006
Added on Jan 26 2006
4 comments
1,589 views