decode with group by
decode with group by
(OP)
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
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
RE: decode with group by
this is the ANSI SQL forum
r937.com | rudy.ca
Buy my new book Simply SQL from Amazon
RE: decode with group by
CODE
from oe_order_headers_all
group by decode(open_flag, 'Y','Yes','No');