sql

yuvalk · September 7th, 2006, 09:19 AM

Hi All,

I have a table as follow :

ID Value
1 aaa
1 bbb
2 ccc
3 ddd

I want to have the following as a result

1 aaa + bbb
2 ccc
3 ddd

that is to concat the columns which their rows have the same ID.

any idea?

Thank you,
Yuval

David_the_DBA · September 8th, 2006, 04:45 PM

Is there a limit to how many rows might have the same id value?

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

yuvalk · September 13th, 2006, 01:35 PM

Hi ,

No there is no limit.
But it will be something like2 or 3 times.

Yuval

Yuval

Mikebrass · September 20th, 2006, 04:51 PM

you can use inline views, at least Oracle's sql has this functionality

yuvalk · September 26th, 2006, 10:16 AM

Hi Mike,

Its sql Server 2000/2005

Yuval

Yuval

Mikebrass · September 26th, 2006, 10:46 AM

it does not really matter. It's sql language.

Mikebrass · September 26th, 2006, 10:47 AM

it does not really matter in this case SQL Server or Oracle or DB2. It's sql language.