Can I use… 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. 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:2016-2. It first appeared in SQL:1999.0