Ways to Specify a Recursive Query - Teradata Database

Ways to Specify a Recursive Query

You can specify a recursive query by:

Preceding a query with the WITH RECURSIVE clause.

Creating a view using the RECURSIVE clause in a CREATE VIEW statement.

For a complete description of the recursive query feature, with examples that illustrate how it is used and its restrictions, see SQL Fundamentals.

For information on WITH RECURSIVE clause, see “WITH Statement Modifier” on page 43.

For information on the RECURSIVE clause in a CREATE VIEW statement, that is, for information on recursive views, see SQL Data Definition Language.