sql query?? how to print all those columns having same id in one row. Can anyone tell the DB2 equivalent also

Question

may be this type of question has been already asked, but i couldn't find it... So i need a little help... Thanks...

Suppose i have a table TABLE1 as...

----------------------
stdcode  |    value  | 
----------------------
1        |     AA    |
----------------------
1        |     AA    |
----------------------
1        |     AC    |
----------------------
1        |     BB    |
----------------------
2        |     BA    |
----------------------
2        |     BD    |
----------------------

and i want to write a sql query which prints the result as...

1 AA;AA;AC;BB
2 BA;BD

DB2 equivalent syntax also required....

@Strawberry yup i did... i think i didn't use a good search term while googling.... Thats why i already mentioned that it may be already asked... anyways.. thanks... — Ashwani Kumar Rahul, Dec 16 '15 at 11:45

score 1 · Accepted Answer · answered Dec 16 '15 at 11:35

1

You are looking for group_concat():

select stdcode, group_concat(value separator ';') as values
from table1
group by stdcode;

answered Dec 16 '15 at 11:35

Gordon Linoff

1,242,037
58
646
786

thanks for the edit and the solution.... – Ashwani Kumar Rahul Dec 16 '15 at 11:49
can you tell the db2 equivalent syntax – Ashwani Kumar Rahul Dec 18 '15 at 09:57
@AshwaniKumarRahul . . . db2 doesn't have a simple function for this purpose. Alas. – Gordon Linoff Dec 18 '15 at 22:49

sql query?? how to print all those columns having same id in one row. Can anyone tell the DB2 equivalent also

1 Answers1