Archives of the TeradataForum

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

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

<-- 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>>