Re: Query Question

On 11 Mar 2005 08:06:13 -0800, "mike" <hillmw_at_charter.net> wrote:

>In the table I have like:
>
>num id
>41 5
>41 6
>41 7
>99 5
>89 9
>
>I was wondering if there is a method where I can generate a result
>dataset from a sql query that looks like:
>
>41 5,6,7
>99 5
>89 9

 It's not very SQL-ish to concatenate values together like that, but it can be done; see following for one approach:

http://asktom.oracle.com/pls/ask/f?p=4950:8:13889121979698050594::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:2196162600402

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool