NEED FOR QUERY [message #408247] |
Mon, 15 June 2009 07:53  |
mamalik
Messages: 270 Registered: November 2008 Location: Pakistan
|
Senior Member |

|
|
ASLAM-O-ALAIKUM DEAR ALL
i have following data in a table.Following is data example.
select 1,'ABC' from dual
union
select 1,'DEF' FROM DUAL
UNION
SELECT 1,'GHI' FROM DUAL
union
select 2,'JKL' from dual
union
select 2,'MNO' FROM DUAL
UNION
SELECT 3,'GHI' FROM DUAL
i need follwoing result from query
1 ABC DEF GHI
2 JKL MNO
3 GHI
How is it possible?
Thanks in advance for your precious time.
Regards.
Asif.
|
|
|
|
|
|