Re: Error at Group By clause

"TR" <tristan_robinson_at_cooltoad.com> wrote in message news:1142872886.773096.235320_at_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.
:

it would be helpful if you posted the entire statement along with the error message, preferably from SQL*Plus with it's error location indication

++ mcs Received on Mon Mar 20 2006 - 12:04:05 CST