Jump to content

Common table expression

Add links
From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Pamar (talk | contribs) at 08:10, 8 June 2006. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

A Common Table Expression (in SQL) is a temporary named result set, derived from a simple query and defined within the execution scope of a SELECT, INSERT, UPDATE, or DELETE statement.

CTE can be thought of as an alternatives to derived tables (subquery), views, and inline user-defined functions.


Stub icon

This software article is a stub. You can help Wikipedia by expanding it.

Retrieved from "https://en.wikipedia.org/w/index.php?title=Common_table_expression&oldid=57500404"