T131, “Recursive query”

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

Related

• Reference: Infinite Recursion Guards

• Tutorial: With — Organize Complex Queries

Normative References

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

You can’t catch up on 20 years of SQL evolution in one day. Subscribe the newsletter via E-Mail, Bluesky or RSS to gradually catch up and to keep modern-⁠sql.com on your radar.

About the Author

Markus Winand provides insights into SQL and shows how different systems support it at modern-sql.com. Previously he made use-the-index-luke.com, which is still actively maintained. Markus can be hired as trainer, speaker and consultant via winand.at.

Buy the Book

The essence of SQL tuning in 200 pages

Buy now!
(paperback and/or PDF)

Paperback also available at Amazon.com.

Hire Markus

Markus offers SQL training and consulting for developers working at companies of all sizes.
Learn more »