Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 12 Jan 2004 @ 11:26:59 GMT

  <Prev Next>  
Next> Last>>  

Subj:   How to concatenate the column values
From:   Vivek Pandey

Hi All,

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.

Thanks, Vivek.

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020