I am trying to concatenate the values of a column from multiple rows into a single column
I want the o/p as 1 a:b:c
I am new to teradata can anyone help me forming the SQL for this requirement
Did you google
teradata recusive sql? this should give you some ideas.
This one might also gives an example
please be aware that the \ need to be removed from the query