Hi

Myreq is:I have emp rable with data as :
100 a
100 b
100 u

it should be displayed as

100 a b c

My qry is :
WITH PARENT (NO, NAME,NAME1,level) as
(SELECT NO, NAME ,NAME,1
FROM IDM_DEV.zz_empt2
WHERE NO =100
UNION ALL
SELECT P.no, C.name,P.name,P.level+1
FROM IDM_DEV.zz_empt2 C
,PARENT P
WHERE P.NO =C.NO
)
SELECT no,name,name1
FROM PARENT where level=2;

I am not getting dsired result..Please suggest any other way to do it
thnaks

there have been many similar requests before
search on pivot data or goto developer works and check for pivot table db2

if v9 you can also use xml functions to acheive same

Can you please give some example,if possible

Aggregating strings
http://groups.google.com/group/comp....b9a03e77a62c93

Why don't you try to search for it, first?