Re: Error at Group By clause

From: TR <tristan_robinson_at_cooltoad.com>
Date: 20 Mar 2006 08:41:26 -0800
Message-ID: <1142872886.773096.235320@i40g2000cwc.googlegroups.com>

Hi,

Thank you for the reply Arian.

But the reply u sent me is still not executing. I am getting the same error. Do we also show Count(*)Total_Items in group by. If so how do we show that? I've tried the following but none of them is executing:

GROUP BY
A.PROD_NUM, B.ITEM_LEVEL, B.PURCHS_DATE, DECODE(C.ITEM,'H',1,0),
DECODE(C.ITEM,'C',1,0); GROUP BY
A.PROD_NUM, B.ITEM_LEVEL, B.PURCHS_DATE, DECODE(C.ITEM,'H',1,0),
DECODE(C.ITEM,'C',1,0),
COUNT(*)TOTAL_ITEMS; GROUP BY
A.PROD_NUM, B.ITEM_LEVEL, B.PURCHS_DATE, DECODE(C.ITEM,'H',1,0),
DECODE(C.ITEM,'C',1,0),
TOTAL_ITEMS; Plz help.

Thank you.

TR. Received on Mon Mar 20 2006 - 10:41:26 CST