Archives of the TeradataForum
Message Posted: Mon, 12 Jan 2004 @ 11:26:59 GMT
I have a table with the following rows.
C1 C2 ========= 1 AB 1 BC 1 CA
I have to concatenate all the values of C2 in to a single field for a given C1 value like this.
C1 C2 =============== 1 AB BC CA
Do u have an idea how to do this. ? I am not supposed to use a shell script for this.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|