Rowset string concatenation

varmamkm

I have a table with the following information

Expand|Select|Wrap|Line Numbers

 CREATE TABLE TEST2 (ID1 INT, NAM1 VARCHAR (20), PLANT VARCHAR (20))

INSERT INTO TEST2 VALUES(1,'AA1','P1')

INSERT INTO TEST2 VALUES(1,'AA1','P2')

INSERT INTO TEST2 VALUES(1,'AA1','P3')

INSERT INTO TEST2 VALUES(1,'AA1','P4')

INSERT INTO TEST2 VALUES(1,'AA1','P5')

INSERT INTO TEST2 VALUES(2,'AA2','P6')

INSERT INTO TEST2 VALUES(2,'AA2','P2')

can anybody help me out to get the result set like this:

Expand|Select|Wrap|Line Numbers

 ID1     NAME1       PLANTS

---     ------      -------------------

1          AA1      P1, P2, P3, P4, P5

2          AA2      P1, P2

thanks in advance

sakumar9

This is not possible with SQL. You can have this kind of output generated with your application.

Regards
--- Sanjay

Rowset string concatenation

re: Rowset string concatenation

Similar DB2 Database bytes

/bytes/development

/bytes/it

/bytes/about