Archives of the TeradataForum
Message Posted: Sat, 06 May 2006 @ 19:57:46 GMT
The answer depends on the database release.
As of V2R6.0 there is an equivalent construct called WITH RECURSIVE.
On earlier releases, there is no ready-to-use equivalent. If you are still using them then you have to write your own code. A stored procedure can be considered for reasonable data volumes.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|