Error ORA-00978
Plugin buscador de errores Nuevo!
Instala gratis el plugin para buscar errores de Oracle directamente desde la barra de tu navegador.
Descripción:
ORA-00978: función de grupo anidada sin GROUP BY (nested group function without GROUP BY)Causa:
Traducción automática de: A group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, was used within another group function, as in MAX(COUNT(*)), without a corresponding GROUP BY clause.Acción:
Traducción automática de: Either add a GROUP BY clause or remove the extra level of nesting.COMENTARIOS:
por Anónimo | 9/11/2006 10:51:19 PM
RE: ORA-00978
select c.name,sum(i.price * i.quantity) ,r.name
from s_customer c,s_ord o,s_item i,s_region r
where c.id = o.customer_id
and o.id = i.ord_id
and c.region_id = r.id
group by c.name,r.name
having sum(i.price * i.quantity) = (select max(sum(i.price * i.quantity))
from s_item i
where i.ord_id = o.id
and c.id = o.customer_id)
Plugin buscador de errores