Common table expression

Common table expression

A Common Table Expression, or CTE, (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.

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

Common table expressions

Common table expressions are supported by DB2, Firebird [1], Microsoft SQL Server, Oracle, PostgreSQL and H2 (experimental)[2]. Syntax:

WITH [RECURSIVE] with_query [, ...]
SELECT...

with_query looks like

with_query_name [ (column_name [,...]) ] AS (SELECT ...)

External links

References



Wikimedia Foundation. 2010.

Игры ⚽ Нужна курсовая?

Look at other dictionaries:

  • Common table expressions — 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… …   Wikipedia

  • Common Lisp — Paradigm(s) Multi paradigm: procedural, functional, object oriented, meta, reflective, generic Appeared in 1984, 1994 for ANSI Common Lisp Developer ANSI X3J13 committee Typing discipline …   Wikipedia

  • Table — Ta ble, n. [F., fr. L. tabula a board, tablet, a painting. Cf. {Tabular}, {Taffrail}, {Tavern}.] 1. A smooth, flat surface, like the side of a board; a thin, flat, smooth piece of anything; a slab. [1913 Webster] A bagnio paved with fair tables… …   The Collaborative International Dictionary of English

  • table — Ta ble, n. [F., fr. L. tabula a board, tablet, a painting. Cf. {Tabular}, {Taffrail}, {Tavern}.] 1. A smooth, flat surface, like the side of a board; a thin, flat, smooth piece of anything; a slab. [1913 Webster] A bagnio paved with fair tables… …   The Collaborative International Dictionary of English

  • Table anvil — Table Ta ble, n. [F., fr. L. tabula a board, tablet, a painting. Cf. {Tabular}, {Taffrail}, {Tavern}.] 1. A smooth, flat surface, like the side of a board; a thin, flat, smooth piece of anything; a slab. [1913 Webster] A bagnio paved with fair… …   The Collaborative International Dictionary of English

  • Table base — Table Ta ble, n. [F., fr. L. tabula a board, tablet, a painting. Cf. {Tabular}, {Taffrail}, {Tavern}.] 1. A smooth, flat surface, like the side of a board; a thin, flat, smooth piece of anything; a slab. [1913 Webster] A bagnio paved with fair… …   The Collaborative International Dictionary of English

  • Table bed — Table Ta ble, n. [F., fr. L. tabula a board, tablet, a painting. Cf. {Tabular}, {Taffrail}, {Tavern}.] 1. A smooth, flat surface, like the side of a board; a thin, flat, smooth piece of anything; a slab. [1913 Webster] A bagnio paved with fair… …   The Collaborative International Dictionary of English

  • Table beer — Table Ta ble, n. [F., fr. L. tabula a board, tablet, a painting. Cf. {Tabular}, {Taffrail}, {Tavern}.] 1. A smooth, flat surface, like the side of a board; a thin, flat, smooth piece of anything; a slab. [1913 Webster] A bagnio paved with fair… …   The Collaborative International Dictionary of English

  • Table bell — Table Ta ble, n. [F., fr. L. tabula a board, tablet, a painting. Cf. {Tabular}, {Taffrail}, {Tavern}.] 1. A smooth, flat surface, like the side of a board; a thin, flat, smooth piece of anything; a slab. [1913 Webster] A bagnio paved with fair… …   The Collaborative International Dictionary of English

  • Table cover — Table Ta ble, n. [F., fr. L. tabula a board, tablet, a painting. Cf. {Tabular}, {Taffrail}, {Tavern}.] 1. A smooth, flat surface, like the side of a board; a thin, flat, smooth piece of anything; a slab. [1913 Webster] A bagnio paved with fair… …   The Collaborative International Dictionary of English

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”