recursive - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

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.