Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix typo in the RANGE documentation of windows functions. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
463da73728db95b3fd67f43450a9f572 |
| User & Date: | drh 2018-07-05 21:13:53 |
Context
|
2018-07-06
| ||
| 18:30 | Update the syntax diagrams to include the new window function syntax. check-in: f7a6a2f7c2 user: drh tags: trunk | |
|
2018-07-05
| ||
| 21:13 | Fix typo in the RANGE documentation of windows functions. check-in: 463da73728 user: drh tags: trunk | |
|
2018-07-02
| ||
| 08:00 | Add a sentence to the FTS3/4 documentation to make it clear that only columns that are part of the FTS3/4 table declaration exist, even if an external content table with more columns is in use. check-in: ea0f0b4c4a user: dan tags: trunk | |
Changes
Changes to pages/windowfunctions.in.
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
...
674
675
676
677
678
679
680
681
682
|
previous row ("1 PRECEDING") and the following row ("1 FOLLOWING"), inclusive,
where rows are sorted according to the ORDER BY clause in the
<i><window-definition></i> (in this case "ORDER BY a"). For example, the frame for the row with (a=3) consists of rows (2, 'B', 'two'), (3, 'C', 'three') and (4, 'D', 'one'). The result of group_concat(b, '.') for that row is therefore 'B.C.D'.
<p> The default <i><frame-specification></i> is:
<codeblock>
RANGE BETWEEN UNBOUNDED PRECEDING TO CURRENT ROW
</codeblock>
<p> This means that, after sorting the rows returned by the SELECT according to
the ORDER BY clause in the <window-definition>, the window frame consists
of all rows between the first row and the last row with the same values as the current row for all ORDER BY expressions. This implies that rows that have the same values for all ORDER BY expressions will also have the same value for the result of the window function (as the window frame is the same). For example:
<codeblock>
................................................................................
<li> <b>xInverse(5)</b> - remove value "5" from the window.
<li> <b>xStep(1)</b> - add value "1" to the window.
<li> <b>xValue()</b> - invoked to obtain the value for row (x='d').
<li> <b>xInverse(3)</b> - remove value "3" from the window. The window now
contains values 8 and 1 only.
<li> <b>xValue()</b> - invoked to obtain the value for row (x='d'). 9.
</ol>
|
|
<
<
|
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
...
674
675
676
677
678
679
680
|
previous row ("1 PRECEDING") and the following row ("1 FOLLOWING"), inclusive,
where rows are sorted according to the ORDER BY clause in the
<i><window-definition></i> (in this case "ORDER BY a"). For example, the frame for the row with (a=3) consists of rows (2, 'B', 'two'), (3, 'C', 'three') and (4, 'D', 'one'). The result of group_concat(b, '.') for that row is therefore 'B.C.D'.
<p> The default <i><frame-specification></i> is:
<codeblock>
RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
</codeblock>
<p> This means that, after sorting the rows returned by the SELECT according to
the ORDER BY clause in the <window-definition>, the window frame consists
of all rows between the first row and the last row with the same values as the current row for all ORDER BY expressions. This implies that rows that have the same values for all ORDER BY expressions will also have the same value for the result of the window function (as the window frame is the same). For example:
<codeblock>
................................................................................
<li> <b>xInverse(5)</b> - remove value "5" from the window.
<li> <b>xStep(1)</b> - add value "1" to the window.
<li> <b>xValue()</b> - invoked to obtain the value for row (x='d').
<li> <b>xInverse(3)</b> - remove value "3" from the window. The window now
contains values 8 and 1 only.
<li> <b>xValue()</b> - invoked to obtain the value for row (x='d'). 9.
</ol>
|