467,882 Members | 1,194 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,882 developers. It's quick & easy.

DB2 SQL Query

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.
Jun 25 '07 #1
  • viewed: 1122
Share:
2 Replies
Order by query on id
and
give group on id and across on code in the form.
Jun 25 '07 #2
Order by query on id
and
give group on id and across on code in the form.
can u give an example ?
Jun 25 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by jaysonsch | last post: by
9 posts views Thread by netpurpose | last post: by
3 posts views Thread by Harvey | last post: by
4 posts views Thread by Diamondback | last post: by
14 posts views Thread by Dave Thomas | last post: by
4 posts views Thread by Stan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.