recursive - Advanced SQL Engine - Teradata Database

The recursive statement is a SELECT statement that retrieves row data from a join of the named query and other tables.

You cannot include NORMALIZE in a recursive statement of a recursive query.

*

All columns of all tables referenced in the FROM clause of the recursive statement be returned.

When qualified by table_name, specifies that all columns of table_name only are to be returned.

seed_selection

Any valid SQL expression, with these exceptions:

• Aggregate functions
• Ordered analytical functions

AS

Optional introduction to expression_alias_name.

expression_alias_name

Alias for the expression.

table_name

Name of the named query or the name of a table or view.

table_name.* in the select list can define the table from which rows are to be returned when two or more tables are referenced in the FROM clause.

FROM

Introduction to the named query and one or more tables or views from which expression is to be derived.

The FROM clause in a recursive statement cannot specify the TABLE option.

where_search_condition

A conditional search expression that must be satisfied by the row or rows returned by the recursive statement.

A value you specify for a row-level security constraint in a search condition must be in encoded form.