Common table expressions
From Seo Wiki - Search Engine Optimization and Programming Languages
| It has been suggested that this article or section be merged into Hierarchical query. (Discuss) |
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.
[edit] Common table expressions
Common table expressions are supported by DB2, Firebird [1], Microsoft SQL Server and PostgreSQL. Syntax:
WITH [RECURSIVE] with_query [, ...] SELECT...
with_query looks like
with_query_name [ (column_name [,...]) ] AS (SELECT ...)
[edit] External links
| File:System-installer.svg | This computer software article is a stub. You can help Wikipedia by expanding it. |
