By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

DB2 SQL Query

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: 2
Order by query on id
and
give group on id and across on code in the form.
Jun 25 '07 #2

P: n/a
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.