Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Error at Group By clause
Hi,
Don't use the aggregate functions in the group by:
GROUP BY
A.PROD_NUM, B.ITEM_LEVEL, B.PURCHS_DATE,
DECODE(C.ITEM,'H',1,0),
DECODE(C.ITEM,'C',1,0)
Regards,
Arian Received on Mon Mar 20 2006 - 10:04:25 CST