All Forums Database
rithu 3 posts Joined 08/12
02 Aug 2012
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

 

ulrich 816 posts Joined 09/09
02 Aug 2012

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-row

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

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

rithu 3 posts Joined 08/12
03 Aug 2012

Thanks a ton!!! I worked for me

You must sign in to leave a comment.