DB2 SQL Query

[sajithamol]

I have data in the table as following :

10 AAA
10 BBB
10 CCC
11 DDD
11 EEE

Where first field is id and second is code , Now , I want to display data as follows :

10 AAA,BBB,CCC
11 DDD,EEE

I want accomplish this using a query not an stored procedure.

[vikalpsuhag]

Order by query on id
and
give group on id and across on code in the form.

[sajithamol]

Order by query on id
and
give group on id and across on code in the form.

can u give an example ?