Help needed in teradata recursive sql

Database
N/A

Help needed in teradata recursive sql

I am trying to concatenate the values of  a column  from multiple rows  into a single column

1 a

1 b

1 c

2 a

2 e

3 a

4 d

I want the o/p as 1 a:b:c

                             2 a:e

                             3 a

                             4 d

I am new to teradata can anyone help me forming the SQL for this requirement

2 REPLIES
N/A

Re: Help needed in teradata recursive sql

Did you google 

teradata recusive sql? this should give you some ideas.

This one might also gives an example

http://forums.teradata.com/forum/database/string-concat-returning-multiple-rows-in-one-string-cocat-...

please be aware that the \ need to be removed from the query

N/A

Re: Help needed in teradata recursive sql

Thanks a ton!!! I worked for me