decode with group by

[raddycal]

I have a select stmt. with decode and a sum. when I put the decode in the group by clause, it says "not a group by expression". when I put the columns from the decode in the group by clause, it says "not a group by expression".
when I put the alias for the decoded value in the group by
clause, it says "not a group by expression". how do I fix this?

thanks

RH

 

[r937]

i wonder if you would be so kind as to re-post this question in the oracle forum (as i believe DECODE is oracle only)

this is the ANSI SQL forum

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[carp]

r937 is correct - DECODE is an Oracle beast, so this should be in the appropriate Oracle forum. With that said, I would also note that the following works fine:

select decode(open_flag, 'Y','Yes','No'), count(*)
from oe_order_headers_all 
group by decode(open_flag, 'Y','Yes','No');

so I believe this is how you fix it.