Home Page for the TeradataForum

Archives of the TeradataForum

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

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