From: "sp" <sdpant@yahoo.com>
Newsgroups: comp.databases.oracle.server
Subject: how to condense several rows of a select?
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <47Ie6.12122$1%2.576363@sjc-read.news.verio.net>
Date: Sat, 03 Feb 2001 00:18:08 GMT
NNTP-Posting-Host: 207.20.18.107
X-Complaints-To: abuse@verio.net
X-Trace: sjc-read.news.verio.net 981159488 207.20.18.107 (Sat, 03 Feb 2001 00:18:08 GMT)
NNTP-Posting-Date: Sat, 03 Feb 2001 00:18:08 GMT
Organization: Verio


I want to condense several rows of a select.
mytable :
1 a
2 b
2 c
2 d
3 a

so that my select should result in

1 a
2 b,c,d
3 a

Any idea to achieve this result?
SP