Re: Weird Query

From: Ronny <nitelyjoy_at_ist-einmalig.de>
Date: Tue, 8 Jul 2008 15:34:32 -0700 (PDT)
Message-ID: <74aab176-791d-451f-acc4-9c26dac1ebe4@z66g2000hsc.googlegroups.com>

Try this:

SELECT SUBSTR (MAX (SYS_CONNECT_BY_PATH (us, ', ')), 3) as your_string

      FROM (SELECT us, ROW_NUMBER () OVER (ORDER BY us) rn
              FROM (SELECT cnt_t_id AS us
                      FROM (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)) x)

START WITH rn = 1
CONNECT BY PRIOR rn = rn - 1;

No warranty - it's untested. Received on Tue Jul 08 2008 - 17:34:32 CDT