Common table expressions

{{

| type = move | image = File:Merge-arrow.svg | imageright = | style = | textstyle = | text = It has been suggested that this article or section be merged into [[::|]]. (Discuss) | small = | smallimage = | smallimageright = | smalltext = }}[[Category:{{Expansion depth limit exceeded|{{{Expansion depth limit exceeded}}}|{{{Expansion depth limit exceeded}}}}}]] 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.

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 ...)

External links

MSDN tutorial

Stub icon

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

This box: [[{{Expansion depth limit exceeded|#default = {{Expansion depth limit exceeded}}

|{{Expansion depth limit exceeded}} = 
   {{Expansion depth limit exceeded| {{Expansion depth limit exceeded}}
     | Template:{{{Expansion depth limit exceeded}}}            
     | {{Expansion depth limit exceeded}}      
   }}

}}|view]] • [[|talk]] • [{{Expansion depth limit exceeded|action=edit}}{{Expansion depth limit exceeded|e|edit}}]

References

↑ http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems#Database_capabilities

If you like SEOmastering Site, you can support it by - BTC: bc1qppjcl3c2cyjazy6lepmrv3fh6ke9mxs7zpfky0 , TRC20 and more...

→

[1] ttp://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems#Database_capabilities

[1]

Common table expressions