Re: Weird Query

On Jul 3, 2:23 pm, Maxim Demenko <mdeme..._at_gmail.com> wrote:
> Mtek schrieb:
>
>
>
> > Hi,
>
> > I have a query which is this:
>
> > SELECT cnt || ':' || t_id cnt_t_id
> > FROM (SELECT COUNT(*) cnt, t_id
> > FROM zc_body zb, zc_type zt
> > WHERE zb.t_id = zt.id
> > GROUP BY t_id);
>
> > The output is this:
>
> > 101:18
> > 49:27
> > 47:36
> > 378:9
> > 118:10
> > 76:15
> > 28:16
> > 38:19
>
> > However, they want the output like this:
>
> > 101:18,49:27,47:36,378:9,118:10,76:15,28:16,38:19
>
> > Can't figure this one out. Do not seem to have any WM_CONCAT or
> > anything. we are on 10g r2.
>
> > Thanks everyone!
>
> > John
>
> Here are provided dozens of different techniques to perform string
> aggregation:http://www.sqlsnippets.com/en/topic-12291.htmlhttp://oracle-base.com/articles/10g/StringAggregationTechniques.php
> (at least, i don't know any other easy method which is not mentioned on
> those links). Some may look more difficult than others. I hope, you can
> pick up one which looks familiar for you and helps you to get desired
> results.
>
> Best regards
>
> Maxim

Thanks, but none of these really do what I want. Most of them work under the assumption that there is a common value in the data, which in this case there is not. I just want a single row from these two joined tables........ Received on Mon Jul 07 2008 - 11:10:24 CDT