Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 05 May 2006 @ 22:19:41 GMT


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


Subj:   CONNECT BY feature of Oracle
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, May 05, 2006 07:35 -->

Hi All,

Does teradata have any function similar to CONNECT BY of Oracle?

What I am looking for is - say I have set of records ordered by Col-2 and I need to compute the value of Col-3 based on Col-2 of previous record. Does teradata have any such feature, if not then is there a way (SQL) to do the same??

     Col-1     Col-2    Col-3
     A          10        1 (default value since this is first record).

     B          20        ?
     C          35        ?

Thanks !



     
  <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: 27 Dec 2016