Documentation Source Text

Check-in [7113d8b989]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Minor tweak to the window function documentation.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 7113d8b989ce1d027d26bcf50b096a30e1511f2350cf2690966eb17fab197952
User & Date: drh 2019-03-28 01:20:38.918
Context
2019-03-28
15:15
Improved railroad diagram for frame-spec. (check-in: 6598d28114 user: drh tags: trunk)
01:20
Minor tweak to the window function documentation. (check-in: 7113d8b989 user: drh tags: trunk)
00:46
Work on the window function documentation. (check-in: 4b4ef30fa6 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/windowfunctions.in.
︙︙
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150

be used as aggregate window functions. It is also possible to 
[user-defined window functions|create user-defined aggregate window functions].


<tcl>hd_fragment ptxn {partition}</tcl>
<h2>The PARTITION BY Clause</h2>

<p> For the purpose of computing window functions, the entire result set
of a query is divided into one or more "partitions".  A partition consists
of all rows that have the same value for all terms of the PARTITION BY clause
in the <yynonterm>window-defn</yynonterm>.  If there is no PARTITION BY clause,
then the entire result set of the query is a single partition.
Window-function processing is performed separately for each partition.

<p> For example:








|








136
137
138
139
140
141
142
143
144
145
146
147
148
149
150

be used as aggregate window functions. It is also possible to 
[user-defined window functions|create user-defined aggregate window functions].


<tcl>hd_fragment ptxn {partition}</tcl>
<h2>The PARTITION BY Clause</h2>

<p> For the purpose of computing window functions, the result set
of a query is divided into one or more "partitions".  A partition consists
of all rows that have the same value for all terms of the PARTITION BY clause
in the <yynonterm>window-defn</yynonterm>.  If there is no PARTITION BY clause,
then the entire result set of the query is a single partition.
Window-function processing is performed separately for each partition.

<p> For example:
︙︙