Let's say I have 3 columns:
order_by. I am trying to do the following:
I would like to concatenate the description for all like
p_id values. So we are talking a
group by p_id sort of thing. But then, I want the description to be concatenated in the order of the
order_by column (which is an integer). So my ideal query (not-working) would look like
select p_id, wm_concat(description) from my_table where p_id = 12345 group by p_id order by order_by asc
How do I concatenate rows in this fashion?