Query Question
From: Mtek <mtek_at_mtekusa.com>
Date: Thu, 19 Jun 2008 10:42:49 -0700 (PDT)
Message-ID: <c80264dd-be17-4754-a00e-483b4182e855@l28g2000prd.googlegroups.com>
Date: Thu, 19 Jun 2008 10:42:49 -0700 (PDT)
Message-ID: <c80264dd-be17-4754-a00e-483b4182e855@l28g2000prd.googlegroups.com>
Hi,
Is it possible to return all rows from a query on one line?
I have this query:
SELECT 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);
It returns data like this:
86:3
994:7
99:18 38:27 45:36
However, they want it in one line: 86:3,994:7,99:18,38:27,45:36
Can this be done?
Thanks!
John Received on Thu Jun 19 2008 - 12:42:49 CDT