17.00 - recursive - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
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.
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.