Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Further clarification on the difference between recursive and ordinary CTEs. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
ecdd0d43d0d120ba2144b924ae815615 |
| User & Date: | drh 2014-02-06 16:52:50 |
Context
|
2014-02-10
| ||
| 17:49 | Fix a typo in the WITH documentation. check-in: 4cd3bb5ab2 user: drh tags: trunk | |
|
2014-02-06
| ||
| 16:52 | Further clarification on the difference between recursive and ordinary CTEs. check-in: ecdd0d43d0 user: drh tags: trunk | |
| 13:25 | Fix an example code error in the WITH documentation. check-in: a6ce882b01 user: drh tags: trunk | |
Changes
Changes to pages/lang.in.
3037 3038 3039 3040 3041 3042 3043 3044 3045 3046 3047 3048 3049 3050 3051 3052 3053 3054 3055 3056 3057 3058 3059 3060 3061 3062 3063 3064 3065 3066 3067 |
<p>Common Table Expressions or CTEs act like temporary [views] that exist
only for the duration of a single SQL statement. There are two kinds of
common table expressions: "ordinary" and "recursive". Ordinary
common table expressions are helpful for making
queries easier to understand by factoring
subqueries out of the main SQL statement.
Recursive common table expression
provide the ability to do hierarchical or
recursive queries of trees and graphs, a capability
that is not otherwise available in the SQL language.
All common table expressions (ordinary and recursive) are
created by prepending a WITH clause in front of a [SELECT], [INSERT], [DELETE],
or [UPDATE] statement. A single WITH clause can specify one or more
common table expressions.
<tcl>hd_fragment ordinarycte {ordinary common table expressions}</tcl>
<h3>Ordinary Common Table Expressions</h3>
<p>An ordinary common table expression works as if it were a [view] that
exists for the duration of a single statement. Ordinary common table
expressions are useful for factoring out subqueries and making the overall
SQL statement easier to read and understand.
<tcl>
hd_fragment recursivecte {recursive common table expressions} \
{recursive query}
</tcl>
<h3>Recursive Common Table Expressions</h3>
|
| | | > > > > > |
3037 3038 3039 3040 3041 3042 3043 3044 3045 3046 3047 3048 3049 3050 3051 3052 3053 3054 3055 3056 3057 3058 3059 3060 3061 3062 3063 3064 3065 3066 3067 3068 3069 3070 3071 3072 |
<p>Common Table Expressions or CTEs act like temporary [views] that exist only for the duration of a single SQL statement. There are two kinds of common table expressions: "ordinary" and "recursive". Ordinary common table expressions are helpful for making queries easier to understand by factoring subqueries out of the main SQL statement. Recursive common table expressions provide the ability to do hierarchical or recursive queries of trees and graphs, a capability that is not otherwise available in the SQL language. <p>All common table expressions (ordinary and recursive) are created by prepending a WITH clause in front of a [SELECT], [INSERT], [DELETE], or [UPDATE] statement. A single WITH clause can specify one or more common table expressions, some of which are ordinary and some of which are recursive. <tcl>hd_fragment ordinarycte {ordinary common table expressions}</tcl> <h3>Ordinary Common Table Expressions</h3> <p>An ordinary common table expression works as if it were a [view] that exists for the duration of a single statement. Ordinary common table expressions are useful for factoring out subqueries and making the overall SQL statement easier to read and understand. <p>A WITH clause can contain ordinary common table expressions even if it includes the RECURSIVE keyword. The use of RECURSIVE does not force common table expressions to be recursive. <tcl> hd_fragment recursivecte {recursive common table expressions} \ {recursive query} </tcl> <h3>Recursive Common Table Expressions</h3> |