0
Without keyword recursive.
1
No join in recursive branch—use comma-join (,).
The with recursive clause allows a query to refer to its own output:
WITH RECURSIVE query_name (column_name, …) AS (
SELECT …
FROM …
UNION ALL
SELECT …
FROM query_name -- <= Note the self-reference here
) [, …]
SELECT …
FROM query_nameRelated
Tutorial:
With— Organize Complex QueriesOther forms:
cycle … set … to … default … using,with,within subquery,with recursivein subquery.Product specific forms:
connect by.
Normative References
The with recursive clause is defined in ISO/IEC 9075:2016-2 as part of optional feature T131.
