Archives of the TeradataForum
Message Posted: Fri, 05 May 2006 @ 22:19:41 GMT
<-- Anonymously Posted: Friday, May 05, 2006 07:35 -->
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 ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|