Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 13 Aug 2002 @ 08:50:34 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Make DISTINCT records and generating sequence number
From:   N.D.Rajesh Kumar

Hi Sreya,

Try this option, but i thing this will work up to some extend, if i am wrong please correct me.

insert into set (columna, columnb, coulumnc,columnd)

select columna,columnb,columnc,csum(1,1)
from multiset;



N.D.Rajesh KumarSystech Solutions, Chennai

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