T131, “Recursive query”

1. Without column list: WITH RECURSIVE query_name AS (SELECT…)
2. Without keyword recursive • No join in recursive branch—use comma-join (,)
3. Without keyword recursive
4. Use cycle … restrict • No using … sub-clause
5. No using … sub-clause
6. Minor deviation: contents of <sequence column>
7. Workaround: use row_number() over() to implement top-N query

Related

• Tutorial: With — Organize Complex Queries

• Product specific forms: cycle…set…to…default, cycle…restrict.

Normative References

T131, “Recursive query”, is an optional feature in ISO/IEC 9075-2:2023. It first appeared in SQL:1999.0