17.00 - recursive - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

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.
Any valid SQL expression, with these exceptions:
  • Aggregate functions
  • Ordered analytical functions
Optional introduction to expression_alias_name.
Alias for the expression.
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.
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.
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.