PL/SQL

From: MeDhanush <medhanush_at_yahoo.com>
Date: 17 Jan 2003 09:29:09 -0800
Message-ID: <15e9d0f4.0301170929.19f804f6_at_posting.google.com>

Hi
Can somebody give me the SELECT query for the following situation.

I have the following table,
ID1 ID2
========= ==========

111111111   	101
111111111   	102
111111111   	103
111111111   	104
111111112   	101
111111112   	102

What would be the query for the following required result.
ID1         	ID2

======== =========
111111111 101,102,103,104
111111112 101,102

TIA
Kishore Received on Fri Jan 17 2003 - 18:29:09 CET