[ DE ]

T121, "`WITH` (excluding `RECURSIVE`) in query expression"

Without column list: WITH name AS (SELECT...)
Supports proprietary syntax with ... insert ... select

Tutorial: With — Organize Complex Queries
Related features: T122, T131, T132.
Product specific forms: with before insert, DML in with.

Normative References

T121, "WITH (excluding RECURSIVE) in query expression", 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

[画像:Photo of Markus Winand]

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.

Footnotes

SQL:1999, formerly known as SQL3 (Eisenberg, Melton)

Can I use...

(beta)

News

The Standard

Concepts

Features

Use Cases

Connect with Markus Winand

Subscribe mailinglists Subscribe the RSS feed Markus Winand on LinkedIn Markus Winand on XING Markus Winand on Twitter Markus Winand on Bluesky

T121, "WITH (excluding RECURSIVE) in query expression"

Related