summaryrefslogtreecommitdiffstats
path: root/www/windowfunctions.html
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--www/windowfunctions.html272
1 files changed, 136 insertions, 136 deletions
diff --git a/www/windowfunctions.html b/www/windowfunctions.html
index d210532..3acd831 100644
--- a/www/windowfunctions.html
+++ b/www/windowfunctions.html
@@ -175,8 +175,8 @@ have a FILTER clause in between the function and the OVER clause.
<p><b><a href="syntax/window-function-invocation.html">window-function-invocation:</a></b>
-<button id='x44e4cb77' onclick='hideorshow("x44e4cb77","xb008b89c")'>hide</button></p>
- <div id='xb008b89c' class='imgcontainer'>
+<button id='x48ad4271' onclick='hideorshow("x48ad4271","x53925228")'>hide</button></p>
+ <div id='x53925228' class='imgcontainer'>
<div style="max-width:870px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 870.446 132.84">
<circle cx="5" cy="55" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,55 20,59 20,50" style="fill:rgb(0,0,0)"/>
@@ -232,8 +232,8 @@ have a FILTER clause in between the function and the OVER clause.
</svg>
</div>
<p><b><a href="syntax/expr.html">expr:</a></b>
-<button id='xde55489c' onclick='hideorshow("xde55489c","xab0ca079")'>show</button></p>
- <div id='xab0ca079' style='display:none;' class='imgcontainer'>
+<button id='xb2746424' onclick='hideorshow("xb2746424","x64380fba")'>show</button></p>
+ <div id='x64380fba' style='display:none;' class='imgcontainer'>
<div style="max-width:963px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 963.96 1068.77">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="45,17 33,21 33,12" style="fill:rgb(0,0,0)"/>
@@ -714,8 +714,8 @@ have a FILTER clause in between the function and the OVER clause.
</svg>
</div>
<p><b><a href="syntax/function-arguments.html">function-arguments:</a></b>
-<button id='xd8262bee' onclick='hideorshow("xd8262bee","xc4e3ffe6")'>show</button></p>
- <div id='xc4e3ffe6' style='display:none;' class='imgcontainer'>
+<button id='x4478980c' onclick='hideorshow("x4478980c","xb3d62a12")'>show</button></p>
+ <div id='xb3d62a12' style='display:none;' class='imgcontainer'>
<div style="max-width:456px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 456.566 223.344">
<circle cx="5" cy="56" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,56 20,60 20,52" style="fill:rgb(0,0,0)"/>
@@ -777,8 +777,8 @@ have a FILTER clause in between the function and the OVER clause.
</svg>
</div>
<p><b><a href="syntax/ordering-term.html">ordering-term:</a></b>
-<button id='x98ae4005' onclick='hideorshow("x98ae4005","x0a87bd5c")'>show</button></p>
- <div id='x0a87bd5c' style='display:none;' class='imgcontainer'>
+<button id='x76291b21' onclick='hideorshow("x76291b21","x7d4fd215")'>show</button></p>
+ <div id='x7d4fd215' style='display:none;' class='imgcontainer'>
<div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -839,8 +839,8 @@ have a FILTER clause in between the function and the OVER clause.
</div>
</div>
<p><b><a href="syntax/literal-value.html">literal-value:</a></b>
-<button id='x4a625953' onclick='hideorshow("x4a625953","x9125574b")'>show</button></p>
- <div id='x9125574b' style='display:none;' class='imgcontainer'>
+<button id='x215fbba5' onclick='hideorshow("x215fbba5","x81da5fe3")'>show</button></p>
+ <div id='x81da5fe3' style='display:none;' class='imgcontainer'>
<div style="max-width:341px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 341.376 336.96">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,319 39,324 39,315" style="fill:rgb(0,0,0)"/>
@@ -910,8 +910,8 @@ have a FILTER clause in between the function and the OVER clause.
</div>
</div>
<p><b><a href="syntax/over-clause.html">over-clause:</a></b>
-<button id='xb0bfa350' onclick='hideorshow("xb0bfa350","x3b0338ed")'>show</button></p>
- <div id='x3b0338ed' style='display:none;' class='imgcontainer'>
+<button id='x1113251e' onclick='hideorshow("x1113251e","xff163cd6")'>show</button></p>
+ <div id='xff163cd6' style='display:none;' class='imgcontainer'>
<div style="max-width:600px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 600.706 418.392">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -1002,8 +1002,8 @@ have a FILTER clause in between the function and the OVER clause.
</svg>
</div>
<p><b><a href="syntax/frame-spec.html">frame-spec:</a></b>
-<button id='x2961ee84' onclick='hideorshow("x2961ee84","x04891692")'>hide</button></p>
- <div id='x04891692' class='imgcontainer'>
+<button id='x4e8e9265' onclick='hideorshow("x4e8e9265","x17ffaecd")'>hide</button></p>
+ <div id='x17ffaecd' class='imgcontainer'>
<div style="max-width:1039px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 1039.65 522.72">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,92 39,97 39,88" style="fill:rgb(0,0,0)"/>
@@ -1212,8 +1212,8 @@ have a FILTER clause in between the function and the OVER clause.
</div>
</div>
<p><b><a href="syntax/ordering-term.html">ordering-term:</a></b>
-<button id='xcf7c2f66' onclick='hideorshow("xcf7c2f66","x4da0c1d5")'>show</button></p>
- <div id='x4da0c1d5' style='display:none;' class='imgcontainer'>
+<button id='x8e41936b' onclick='hideorshow("x8e41936b","x6fd1ecaf")'>show</button></p>
+ <div id='x6fd1ecaf' style='display:none;' class='imgcontainer'>
<div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -1274,8 +1274,8 @@ have a FILTER clause in between the function and the OVER clause.
</div>
</div>
<p><b><a href="syntax/raise-function.html">raise-function:</a></b>
-<button id='xd499344a' onclick='hideorshow("xd499344a","x86451066")'>show</button></p>
- <div id='x86451066' style='display:none;' class='imgcontainer'>
+<button id='x994542dd' onclick='hideorshow("x994542dd","x8b34c08b")'>show</button></p>
+ <div id='x8b34c08b' style='display:none;' class='imgcontainer'>
<div style="max-width:627px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 627.302 147.96">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -1330,8 +1330,8 @@ have a FILTER clause in between the function and the OVER clause.
</div>
</div>
<p><b><a href="syntax/select-stmt.html">select-stmt:</a></b>
-<button id='x3e9b2388' onclick='hideorshow("x3e9b2388","x1db2093e")'>show</button></p>
- <div id='x1db2093e' style='display:none;' class='imgcontainer'>
+<button id='x0ed31772' onclick='hideorshow("x0ed31772","x95a67155")'>show</button></p>
+ <div id='x95a67155' style='display:none;' class='imgcontainer'>
<div style="max-width:669px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 669.677 1162.3">
<path d="M55,845L667,845L667,99L55,99Z" style="fill:none;stroke-width:3.24;stroke:rgb(211,211,211);" />
<circle cx="6" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
@@ -1609,8 +1609,8 @@ have a FILTER clause in between the function and the OVER clause.
</svg>
</div>
<p><b><a href="syntax/common-table-expression.html">common-table-expression:</a></b>
-<button id='x22e81d6a' onclick='hideorshow("x22e81d6a","x4c1ab371")'>show</button></p>
- <div id='x4c1ab371' style='display:none;' class='imgcontainer'>
+<button id='x5c775959' onclick='hideorshow("x5c775959","x4c86bd0e")'>show</button></p>
+ <div id='x4c86bd0e' style='display:none;' class='imgcontainer'>
<div style="max-width:638px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 638.525 167.4">
<circle cx="5" cy="29" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,29 20,33 20,24" style="fill:rgb(0,0,0)"/>
@@ -1680,8 +1680,8 @@ have a FILTER clause in between the function and the OVER clause.
</div>
</div>
<p><b><a href="syntax/compound-operator.html">compound-operator:</a></b>
-<button id='x89950653' onclick='hideorshow("x89950653","xceff8d96")'>show</button></p>
- <div id='xceff8d96' style='display:none;' class='imgcontainer'>
+<button id='x2a0433b1' onclick='hideorshow("x2a0433b1","x2a5ff775")'>show</button></p>
+ <div id='x2a5ff775' style='display:none;' class='imgcontainer'>
<div style="max-width:293px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 293.842 147.96">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -1722,8 +1722,8 @@ have a FILTER clause in between the function and the OVER clause.
</div>
</div>
<p><b><a href="syntax/join-clause.html">join-clause:</a></b>
-<button id='x5ecb3f06' onclick='hideorshow("x5ecb3f06","x25642fa8")'>show</button></p>
- <div id='x25642fa8' style='display:none;' class='imgcontainer'>
+<button id='x3513ae9f' onclick='hideorshow("x3513ae9f","x25979698")'>show</button></p>
+ <div id='x25979698' style='display:none;' class='imgcontainer'>
<div style="max-width:793px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 793.282 84.24">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -1754,8 +1754,8 @@ have a FILTER clause in between the function and the OVER clause.
</svg>
</div>
<p><b><a href="syntax/join-constraint.html">join-constraint:</a></b>
-<button id='x9f0e73e3' onclick='hideorshow("x9f0e73e3","x105195d3")'>show</button></p>
- <div id='x105195d3' style='display:none;' class='imgcontainer'>
+<button id='x7994968a' onclick='hideorshow("x7994968a","x2661b185")'>show</button></p>
+ <div id='x2661b185' style='display:none;' class='imgcontainer'>
<div style="max-width:483px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 483.336 126.576">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,55 39,59 39,50" style="fill:rgb(0,0,0)"/>
@@ -1802,8 +1802,8 @@ have a FILTER clause in between the function and the OVER clause.
</div>
</div>
<p><b><a href="syntax/join-operator.html">join-operator:</a></b>
-<button id='xfa31f036' onclick='hideorshow("xfa31f036","x58a596b4")'>show</button></p>
- <div id='x58a596b4' style='display:none;' class='imgcontainer'>
+<button id='x42064693' onclick='hideorshow("x42064693","x950dfd4a")'>show</button></p>
+ <div id='x950dfd4a' style='display:none;' class='imgcontainer'>
<div style="max-width:620px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 620.333 255.312">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,71 39,76 39,67" style="fill:rgb(0,0,0)"/>
@@ -1870,8 +1870,8 @@ have a FILTER clause in between the function and the OVER clause.
</div>
</div>
<p><b><a href="syntax/ordering-term.html">ordering-term:</a></b>
-<button id='x50e5887c' onclick='hideorshow("x50e5887c","x3985c24c")'>show</button></p>
- <div id='x3985c24c' style='display:none;' class='imgcontainer'>
+<button id='xd4106520' onclick='hideorshow("xd4106520","x5cd745fd")'>show</button></p>
+ <div id='x5cd745fd' style='display:none;' class='imgcontainer'>
<div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -1931,8 +1931,8 @@ have a FILTER clause in between the function and the OVER clause.
</div>
</div>
<p><b><a href="syntax/result-column.html">result-column:</a></b>
-<button id='x0857d62f' onclick='hideorshow("x0857d62f","x094cf564")'>show</button></p>
- <div id='x094cf564' style='display:none;' class='imgcontainer'>
+<button id='x409b09bb' onclick='hideorshow("x409b09bb","x875cc923")'>show</button></p>
+ <div id='x875cc923' style='display:none;' class='imgcontainer'>
<div style="max-width:398px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 398.054 163.08">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="45,17 33,21 33,12" style="fill:rgb(0,0,0)"/>
@@ -1984,8 +1984,8 @@ have a FILTER clause in between the function and the OVER clause.
</div>
</div>
<p><b><a href="syntax/table-or-subquery.html">table-or-subquery:</a></b>
-<button id='xee1e290d' onclick='hideorshow("xee1e290d","x1d3f9721")'>show</button></p>
- <div id='x1d3f9721' style='display:none;' class='imgcontainer'>
+<button id='x827d9266' onclick='hideorshow("x827d9266","x9829c2ab")'>show</button></p>
+ <div id='x9829c2ab' style='display:none;' class='imgcontainer'>
<div style="max-width:720px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 720.778 457.704">
<circle cx="5" cy="36" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,74 39,78 39,70" style="fill:rgb(0,0,0)"/>
@@ -2130,8 +2130,8 @@ have a FILTER clause in between the function and the OVER clause.
</div>
</div>
<p><b><a href="syntax/type-name.html">type-name:</a></b>
-<button id='xcf057e45' onclick='hideorshow("xcf057e45","xdd8e2cf1")'>show</button></p>
- <div id='xdd8e2cf1' style='display:none;' class='imgcontainer'>
+<button id='x9818642d' onclick='hideorshow("x9818642d","x6455eb06")'>show</button></p>
+ <div id='x6455eb06' style='display:none;' class='imgcontainer'>
<div style="max-width:661px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 661.008 110.16">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="45,17 33,21 33,12" style="fill:rgb(0,0,0)"/>
@@ -2185,8 +2185,8 @@ have a FILTER clause in between the function and the OVER clause.
</svg>
</div>
<p><b><a href="syntax/signed-number.html">signed-number:</a></b>
-<button id='xbfbe88e9' onclick='hideorshow("xbfbe88e9","x27d3cd5a")'>show</button></p>
- <div id='x27d3cd5a' style='display:none;' class='imgcontainer'>
+<button id='x75542a8b' onclick='hideorshow("x75542a8b","x04d29758")'>show</button></p>
+ <div id='x04d29758' style='display:none;' class='imgcontainer'>
<div style="max-width:292px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 292.013 99.576">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,44 39,48 39,40" style="fill:rgb(0,0,0)"/>
@@ -2214,8 +2214,8 @@ have a FILTER clause in between the function and the OVER clause.
</div>
</div>
<p><b><a href="syntax/filter-clause.html">filter-clause:</a></b>
-<button id='x42666c57' onclick='hideorshow("x42666c57","x3adc8ba7")'>hide</button></p>
- <div id='x3adc8ba7' class='imgcontainer'>
+<button id='xf2f57ed1' onclick='hideorshow("xf2f57ed1","xe8bc788f")'>hide</button></p>
+ <div id='xe8bc788f' class='imgcontainer'>
<div style="max-width:422px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 422.381 34.56">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -2245,8 +2245,8 @@ have a FILTER clause in between the function and the OVER clause.
</div>
</div>
<p><b><a href="syntax/window-defn.html">window-defn:</a></b>
-<button id='x792b9975' onclick='hideorshow("x792b9975","x477af11c")'>hide</button></p>
- <div id='x477af11c' class='imgcontainer'>
+<button id='x0ac8b2da' onclick='hideorshow("x0ac8b2da","x8e58a488")'>hide</button></p>
+ <div id='x8e58a488' class='imgcontainer'>
<div style="max-width:479px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 479.765 380.592">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -2326,8 +2326,8 @@ have a FILTER clause in between the function and the OVER clause.
</svg>
</div>
<p><b><a href="syntax/frame-spec.html">frame-spec:</a></b>
-<button id='x3af3f931' onclick='hideorshow("x3af3f931","xc7f772f6")'>hide</button></p>
- <div id='xc7f772f6' class='imgcontainer'>
+<button id='xdbb8ae77' onclick='hideorshow("xdbb8ae77","x0842b931")'>hide</button></p>
+ <div id='x0842b931' class='imgcontainer'>
<div style="max-width:1039px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 1039.65 522.72">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,92 39,97 39,88" style="fill:rgb(0,0,0)"/>
@@ -2536,8 +2536,8 @@ have a FILTER clause in between the function and the OVER clause.
</div>
</div>
<p><b><a href="syntax/ordering-term.html">ordering-term:</a></b>
-<button id='xe0fe7824' onclick='hideorshow("xe0fe7824","x537a9e34")'>show</button></p>
- <div id='x537a9e34' style='display:none;' class='imgcontainer'>
+<button id='xb69c6776' onclick='hideorshow("xb69c6776","xd86e3a7e")'>show</button></p>
+ <div id='xd86e3a7e' style='display:none;' class='imgcontainer'>
<div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -2609,7 +2609,7 @@ ORDER BY clause of a SELECT statement.
</p><p>Window functions come in two varieties:
<a href="windowfunctions.html#aggwinfunc">aggregate window functions</a> and
<a href="windowfunctions.html#builtins">built-in window functions</a>. Every aggregate window function
-can also work as a ordinary aggregate function, simply by omitting
+can also work as an ordinary aggregate function, simply by omitting
the OVER and FILTER clauses. Furthermore, all of the built-in
<a href="lang_aggfunc.html">aggregate functions</a> of SQLite can be used as an
aggregate window function by adding an appropriate OVER clause.
@@ -2797,8 +2797,8 @@ read by an aggregate window function. The
<p> Here are the syntax details:
<p><b><a href="syntax/frame-spec.html">frame-spec:</a></b>
-<button id='x0199aef6' onclick='hideorshow("x0199aef6","x56b9bd0c")'>hide</button></p>
- <div id='x56b9bd0c' class='imgcontainer'>
+<button id='x2d48b895' onclick='hideorshow("x2d48b895","xf29b33b1")'>hide</button></p>
+ <div id='xf29b33b1' class='imgcontainer'>
<div style="max-width:1039px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 1039.65 522.72">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,92 39,97 39,88" style="fill:rgb(0,0,0)"/>
@@ -3006,8 +3006,8 @@ read by an aggregate window function. The
</svg>
</div>
<p><b><a href="syntax/expr.html">expr:</a></b>
-<button id='xac4aee76' onclick='hideorshow("xac4aee76","x789c4ff5")'>show</button></p>
- <div id='x789c4ff5' style='display:none;' class='imgcontainer'>
+<button id='x535031ae' onclick='hideorshow("x535031ae","x5898a7c9")'>show</button></p>
+ <div id='x5898a7c9' style='display:none;' class='imgcontainer'>
<div style="max-width:963px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 963.96 1068.77">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="45,17 33,21 33,12" style="fill:rgb(0,0,0)"/>
@@ -3488,8 +3488,8 @@ read by an aggregate window function. The
</svg>
</div>
<p><b><a href="syntax/filter-clause.html">filter-clause:</a></b>
-<button id='x6e5adba8' onclick='hideorshow("x6e5adba8","xdbb0e8d4")'>show</button></p>
- <div id='xdbb0e8d4' style='display:none;' class='imgcontainer'>
+<button id='xa2ba9142' onclick='hideorshow("xa2ba9142","xb4adf57b")'>show</button></p>
+ <div id='xb4adf57b' style='display:none;' class='imgcontainer'>
<div style="max-width:422px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 422.381 34.56">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -3519,8 +3519,8 @@ read by an aggregate window function. The
</div>
</div>
<p><b><a href="syntax/function-arguments.html">function-arguments:</a></b>
-<button id='x62f7c893' onclick='hideorshow("x62f7c893","x2e28c5e5")'>show</button></p>
- <div id='x2e28c5e5' style='display:none;' class='imgcontainer'>
+<button id='xde7e5666' onclick='hideorshow("xde7e5666","x7c405d41")'>show</button></p>
+ <div id='x7c405d41' style='display:none;' class='imgcontainer'>
<div style="max-width:456px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 456.566 223.344">
<circle cx="5" cy="56" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,56 20,60 20,52" style="fill:rgb(0,0,0)"/>
@@ -3582,8 +3582,8 @@ read by an aggregate window function. The
</svg>
</div>
<p><b><a href="syntax/ordering-term.html">ordering-term:</a></b>
-<button id='xa4e5c48b' onclick='hideorshow("xa4e5c48b","xf02c44ea")'>show</button></p>
- <div id='xf02c44ea' style='display:none;' class='imgcontainer'>
+<button id='xaca473da' onclick='hideorshow("xaca473da","xbdfb6faa")'>show</button></p>
+ <div id='xbdfb6faa' style='display:none;' class='imgcontainer'>
<div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -3644,8 +3644,8 @@ read by an aggregate window function. The
</div>
</div>
<p><b><a href="syntax/literal-value.html">literal-value:</a></b>
-<button id='x7c347ea1' onclick='hideorshow("x7c347ea1","x94bc3bbf")'>show</button></p>
- <div id='x94bc3bbf' style='display:none;' class='imgcontainer'>
+<button id='x8c815ca5' onclick='hideorshow("x8c815ca5","xf97a6947")'>show</button></p>
+ <div id='xf97a6947' style='display:none;' class='imgcontainer'>
<div style="max-width:341px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 341.376 336.96">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,319 39,324 39,315" style="fill:rgb(0,0,0)"/>
@@ -3715,8 +3715,8 @@ read by an aggregate window function. The
</div>
</div>
<p><b><a href="syntax/over-clause.html">over-clause:</a></b>
-<button id='x52470a2d' onclick='hideorshow("x52470a2d","x792b8a02")'>show</button></p>
- <div id='x792b8a02' style='display:none;' class='imgcontainer'>
+<button id='x316aaf72' onclick='hideorshow("x316aaf72","x9c859035")'>show</button></p>
+ <div id='x9c859035' style='display:none;' class='imgcontainer'>
<div style="max-width:600px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 600.706 418.392">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -3807,8 +3807,8 @@ read by an aggregate window function. The
</svg>
</div>
<p><b><a href="syntax/ordering-term.html">ordering-term:</a></b>
-<button id='x85933096' onclick='hideorshow("x85933096","x08cc4720")'>show</button></p>
- <div id='x08cc4720' style='display:none;' class='imgcontainer'>
+<button id='xcbe16931' onclick='hideorshow("xcbe16931","x134b52e3")'>show</button></p>
+ <div id='x134b52e3' style='display:none;' class='imgcontainer'>
<div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -3869,8 +3869,8 @@ read by an aggregate window function. The
</div>
</div>
<p><b><a href="syntax/raise-function.html">raise-function:</a></b>
-<button id='x78ec9ddf' onclick='hideorshow("x78ec9ddf","xaaf6e4dd")'>show</button></p>
- <div id='xaaf6e4dd' style='display:none;' class='imgcontainer'>
+<button id='xe58b1bb9' onclick='hideorshow("xe58b1bb9","x544978e2")'>show</button></p>
+ <div id='x544978e2' style='display:none;' class='imgcontainer'>
<div style="max-width:627px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 627.302 147.96">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -3925,8 +3925,8 @@ read by an aggregate window function. The
</div>
</div>
<p><b><a href="syntax/select-stmt.html">select-stmt:</a></b>
-<button id='x55ed670b' onclick='hideorshow("x55ed670b","x8d102754")'>show</button></p>
- <div id='x8d102754' style='display:none;' class='imgcontainer'>
+<button id='xd6121c61' onclick='hideorshow("xd6121c61","xb2ebe95d")'>show</button></p>
+ <div id='xb2ebe95d' style='display:none;' class='imgcontainer'>
<div style="max-width:669px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 669.677 1162.3">
<path d="M55,845L667,845L667,99L55,99Z" style="fill:none;stroke-width:3.24;stroke:rgb(211,211,211);" />
<circle cx="6" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
@@ -4204,8 +4204,8 @@ read by an aggregate window function. The
</svg>
</div>
<p><b><a href="syntax/common-table-expression.html">common-table-expression:</a></b>
-<button id='xb5f243c6' onclick='hideorshow("xb5f243c6","x9ff2c574")'>show</button></p>
- <div id='x9ff2c574' style='display:none;' class='imgcontainer'>
+<button id='xcdb1b778' onclick='hideorshow("xcdb1b778","xae5136de")'>show</button></p>
+ <div id='xae5136de' style='display:none;' class='imgcontainer'>
<div style="max-width:638px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 638.525 167.4">
<circle cx="5" cy="29" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,29 20,33 20,24" style="fill:rgb(0,0,0)"/>
@@ -4275,8 +4275,8 @@ read by an aggregate window function. The
</div>
</div>
<p><b><a href="syntax/compound-operator.html">compound-operator:</a></b>
-<button id='x91d419e5' onclick='hideorshow("x91d419e5","x5d685770")'>show</button></p>
- <div id='x5d685770' style='display:none;' class='imgcontainer'>
+<button id='xab893daf' onclick='hideorshow("xab893daf","xcbd83a12")'>show</button></p>
+ <div id='xcbd83a12' style='display:none;' class='imgcontainer'>
<div style="max-width:293px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 293.842 147.96">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -4317,8 +4317,8 @@ read by an aggregate window function. The
</div>
</div>
<p><b><a href="syntax/join-clause.html">join-clause:</a></b>
-<button id='xefb9c824' onclick='hideorshow("xefb9c824","x3aab8e3c")'>show</button></p>
- <div id='x3aab8e3c' style='display:none;' class='imgcontainer'>
+<button id='xde46189e' onclick='hideorshow("xde46189e","x948e1885")'>show</button></p>
+ <div id='x948e1885' style='display:none;' class='imgcontainer'>
<div style="max-width:793px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 793.282 84.24">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -4349,8 +4349,8 @@ read by an aggregate window function. The
</svg>
</div>
<p><b><a href="syntax/join-constraint.html">join-constraint:</a></b>
-<button id='x1bff3899' onclick='hideorshow("x1bff3899","x2354f933")'>show</button></p>
- <div id='x2354f933' style='display:none;' class='imgcontainer'>
+<button id='xd1111596' onclick='hideorshow("xd1111596","x60d743e2")'>show</button></p>
+ <div id='x60d743e2' style='display:none;' class='imgcontainer'>
<div style="max-width:483px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 483.336 126.576">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,55 39,59 39,50" style="fill:rgb(0,0,0)"/>
@@ -4397,8 +4397,8 @@ read by an aggregate window function. The
</div>
</div>
<p><b><a href="syntax/join-operator.html">join-operator:</a></b>
-<button id='xd89646f0' onclick='hideorshow("xd89646f0","x06401d72")'>show</button></p>
- <div id='x06401d72' style='display:none;' class='imgcontainer'>
+<button id='xd0cf6393' onclick='hideorshow("xd0cf6393","x2f88c1d8")'>show</button></p>
+ <div id='x2f88c1d8' style='display:none;' class='imgcontainer'>
<div style="max-width:620px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 620.333 255.312">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,71 39,76 39,67" style="fill:rgb(0,0,0)"/>
@@ -4465,8 +4465,8 @@ read by an aggregate window function. The
</div>
</div>
<p><b><a href="syntax/ordering-term.html">ordering-term:</a></b>
-<button id='xfb6a9b78' onclick='hideorshow("xfb6a9b78","xad22eab0")'>show</button></p>
- <div id='xad22eab0' style='display:none;' class='imgcontainer'>
+<button id='x32cb9fc5' onclick='hideorshow("x32cb9fc5","xa1e90b9e")'>show</button></p>
+ <div id='xa1e90b9e' style='display:none;' class='imgcontainer'>
<div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -4526,8 +4526,8 @@ read by an aggregate window function. The
</div>
</div>
<p><b><a href="syntax/result-column.html">result-column:</a></b>
-<button id='xdb83a7b9' onclick='hideorshow("xdb83a7b9","xcca4ae9d")'>show</button></p>
- <div id='xcca4ae9d' style='display:none;' class='imgcontainer'>
+<button id='x445e0b16' onclick='hideorshow("x445e0b16","xaa77a6e7")'>show</button></p>
+ <div id='xaa77a6e7' style='display:none;' class='imgcontainer'>
<div style="max-width:398px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 398.054 163.08">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="45,17 33,21 33,12" style="fill:rgb(0,0,0)"/>
@@ -4579,8 +4579,8 @@ read by an aggregate window function. The
</div>
</div>
<p><b><a href="syntax/table-or-subquery.html">table-or-subquery:</a></b>
-<button id='x5c9faa54' onclick='hideorshow("x5c9faa54","x02ce5f50")'>show</button></p>
- <div id='x02ce5f50' style='display:none;' class='imgcontainer'>
+<button id='xc19e5848' onclick='hideorshow("xc19e5848","xe56e459d")'>show</button></p>
+ <div id='xe56e459d' style='display:none;' class='imgcontainer'>
<div style="max-width:720px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 720.778 457.704">
<circle cx="5" cy="36" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,74 39,78 39,70" style="fill:rgb(0,0,0)"/>
@@ -4724,8 +4724,8 @@ read by an aggregate window function. The
</div>
</div>
<p><b><a href="syntax/window-defn.html">window-defn:</a></b>
-<button id='xb0d1461b' onclick='hideorshow("xb0d1461b","xa8f015e1")'>show</button></p>
- <div id='xa8f015e1' style='display:none;' class='imgcontainer'>
+<button id='x02de707e' onclick='hideorshow("x02de707e","xe3bca836")'>show</button></p>
+ <div id='xe3bca836' style='display:none;' class='imgcontainer'>
<div style="max-width:479px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 479.765 380.592">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -4807,8 +4807,8 @@ read by an aggregate window function. The
</div>
</div>
<p><b><a href="syntax/type-name.html">type-name:</a></b>
-<button id='x187bb7f1' onclick='hideorshow("x187bb7f1","x2230c8ce")'>show</button></p>
- <div id='x2230c8ce' style='display:none;' class='imgcontainer'>
+<button id='xd448932b' onclick='hideorshow("xd448932b","xe9a3227c")'>show</button></p>
+ <div id='xe9a3227c' style='display:none;' class='imgcontainer'>
<div style="max-width:661px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 661.008 110.16">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="45,17 33,21 33,12" style="fill:rgb(0,0,0)"/>
@@ -4862,8 +4862,8 @@ read by an aggregate window function. The
</svg>
</div>
<p><b><a href="syntax/signed-number.html">signed-number:</a></b>
-<button id='x2e27fd13' onclick='hideorshow("x2e27fd13","x3f3bc4fd")'>show</button></p>
- <div id='x3f3bc4fd' style='display:none;' class='imgcontainer'>
+<button id='x4bb1a0c0' onclick='hideorshow("x4bb1a0c0","x25a888e5")'>show</button></p>
+ <div id='x25a888e5' style='display:none;' class='imgcontainer'>
<div style="max-width:292px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 292.013 99.576">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,44 39,48 39,40" style="fill:rgb(0,0,0)"/>
@@ -5145,8 +5145,8 @@ FROM t1 ORDER BY c, a;
<h2 id="the_filter_clause"><span>2.3. </span>The FILTER Clause</h2>
<p><b><a href="syntax/filter-clause.html">filter-clause:</a></b>
-<button id='x9c6ef48a' onclick='hideorshow("x9c6ef48a","x4dc11b33")'>hide</button></p>
- <div id='x4dc11b33' class='imgcontainer'>
+<button id='xdfe67349' onclick='hideorshow("xdfe67349","x80505591")'>hide</button></p>
+ <div id='x80505591' class='imgcontainer'>
<div style="max-width:422px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 422.381 34.56">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -5175,8 +5175,8 @@ FROM t1 ORDER BY c, a;
</svg>
</div>
<p><b><a href="syntax/expr.html">expr:</a></b>
-<button id='xdc983a44' onclick='hideorshow("xdc983a44","x697d9515")'>show</button></p>
- <div id='x697d9515' style='display:none;' class='imgcontainer'>
+<button id='xa2fc8f5d' onclick='hideorshow("xa2fc8f5d","xb80e9d88")'>show</button></p>
+ <div id='xb80e9d88' style='display:none;' class='imgcontainer'>
<div style="max-width:963px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 963.96 1068.77">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="45,17 33,21 33,12" style="fill:rgb(0,0,0)"/>
@@ -5657,8 +5657,8 @@ FROM t1 ORDER BY c, a;
</svg>
</div>
<p><b><a href="syntax/function-arguments.html">function-arguments:</a></b>
-<button id='x7f57e866' onclick='hideorshow("x7f57e866","xd7a5c5d5")'>show</button></p>
- <div id='xd7a5c5d5' style='display:none;' class='imgcontainer'>
+<button id='xf6ac8e66' onclick='hideorshow("xf6ac8e66","xec5b4a4b")'>show</button></p>
+ <div id='xec5b4a4b' style='display:none;' class='imgcontainer'>
<div style="max-width:456px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 456.566 223.344">
<circle cx="5" cy="56" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,56 20,60 20,52" style="fill:rgb(0,0,0)"/>
@@ -5720,8 +5720,8 @@ FROM t1 ORDER BY c, a;
</svg>
</div>
<p><b><a href="syntax/ordering-term.html">ordering-term:</a></b>
-<button id='x085f9125' onclick='hideorshow("x085f9125","xa064d583")'>show</button></p>
- <div id='xa064d583' style='display:none;' class='imgcontainer'>
+<button id='x4dd4cd8d' onclick='hideorshow("x4dd4cd8d","x9cc14ebe")'>show</button></p>
+ <div id='x9cc14ebe' style='display:none;' class='imgcontainer'>
<div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -5782,8 +5782,8 @@ FROM t1 ORDER BY c, a;
</div>
</div>
<p><b><a href="syntax/literal-value.html">literal-value:</a></b>
-<button id='x301b5e69' onclick='hideorshow("x301b5e69","x7dbaddb3")'>show</button></p>
- <div id='x7dbaddb3' style='display:none;' class='imgcontainer'>
+<button id='x28c234c3' onclick='hideorshow("x28c234c3","x8fafc3ce")'>show</button></p>
+ <div id='x8fafc3ce' style='display:none;' class='imgcontainer'>
<div style="max-width:341px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 341.376 336.96">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,319 39,324 39,315" style="fill:rgb(0,0,0)"/>
@@ -5853,8 +5853,8 @@ FROM t1 ORDER BY c, a;
</div>
</div>
<p><b><a href="syntax/over-clause.html">over-clause:</a></b>
-<button id='xd98e3155' onclick='hideorshow("xd98e3155","x17f939ee")'>show</button></p>
- <div id='x17f939ee' style='display:none;' class='imgcontainer'>
+<button id='x4682c9e8' onclick='hideorshow("x4682c9e8","xe4d4002e")'>show</button></p>
+ <div id='xe4d4002e' style='display:none;' class='imgcontainer'>
<div style="max-width:600px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 600.706 418.392">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -5945,8 +5945,8 @@ FROM t1 ORDER BY c, a;
</svg>
</div>
<p><b><a href="syntax/frame-spec.html">frame-spec:</a></b>
-<button id='x36e52421' onclick='hideorshow("x36e52421","x0f9f75a4")'>show</button></p>
- <div id='x0f9f75a4' style='display:none;' class='imgcontainer'>
+<button id='xe32bb2d7' onclick='hideorshow("xe32bb2d7","x48dd3ee9")'>show</button></p>
+ <div id='x48dd3ee9' style='display:none;' class='imgcontainer'>
<div style="max-width:1039px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 1039.65 522.72">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,92 39,97 39,88" style="fill:rgb(0,0,0)"/>
@@ -6155,8 +6155,8 @@ FROM t1 ORDER BY c, a;
</div>
</div>
<p><b><a href="syntax/ordering-term.html">ordering-term:</a></b>
-<button id='x1df87fd8' onclick='hideorshow("x1df87fd8","x420baa92")'>show</button></p>
- <div id='x420baa92' style='display:none;' class='imgcontainer'>
+<button id='x4cead0b3' onclick='hideorshow("x4cead0b3","xb4ecb865")'>show</button></p>
+ <div id='xb4ecb865' style='display:none;' class='imgcontainer'>
<div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -6217,8 +6217,8 @@ FROM t1 ORDER BY c, a;
</div>
</div>
<p><b><a href="syntax/raise-function.html">raise-function:</a></b>
-<button id='x4a5943b5' onclick='hideorshow("x4a5943b5","x85d7df8c")'>show</button></p>
- <div id='x85d7df8c' style='display:none;' class='imgcontainer'>
+<button id='x6dd82a26' onclick='hideorshow("x6dd82a26","xfec4a21d")'>show</button></p>
+ <div id='xfec4a21d' style='display:none;' class='imgcontainer'>
<div style="max-width:627px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 627.302 147.96">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -6273,8 +6273,8 @@ FROM t1 ORDER BY c, a;
</div>
</div>
<p><b><a href="syntax/select-stmt.html">select-stmt:</a></b>
-<button id='xb11a1037' onclick='hideorshow("xb11a1037","x12d9418a")'>show</button></p>
- <div id='x12d9418a' style='display:none;' class='imgcontainer'>
+<button id='xc07d1e39' onclick='hideorshow("xc07d1e39","x063a4d98")'>show</button></p>
+ <div id='x063a4d98' style='display:none;' class='imgcontainer'>
<div style="max-width:669px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 669.677 1162.3">
<path d="M55,845L667,845L667,99L55,99Z" style="fill:none;stroke-width:3.24;stroke:rgb(211,211,211);" />
<circle cx="6" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
@@ -6552,8 +6552,8 @@ FROM t1 ORDER BY c, a;
</svg>
</div>
<p><b><a href="syntax/common-table-expression.html">common-table-expression:</a></b>
-<button id='x09152732' onclick='hideorshow("x09152732","x4c0fda46")'>show</button></p>
- <div id='x4c0fda46' style='display:none;' class='imgcontainer'>
+<button id='xd4ddba1a' onclick='hideorshow("xd4ddba1a","xded90b1e")'>show</button></p>
+ <div id='xded90b1e' style='display:none;' class='imgcontainer'>
<div style="max-width:638px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 638.525 167.4">
<circle cx="5" cy="29" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,29 20,33 20,24" style="fill:rgb(0,0,0)"/>
@@ -6623,8 +6623,8 @@ FROM t1 ORDER BY c, a;
</div>
</div>
<p><b><a href="syntax/compound-operator.html">compound-operator:</a></b>
-<button id='xbe4aff98' onclick='hideorshow("xbe4aff98","xbacc089d")'>show</button></p>
- <div id='xbacc089d' style='display:none;' class='imgcontainer'>
+<button id='x9b0ac1ee' onclick='hideorshow("x9b0ac1ee","x2ead26cf")'>show</button></p>
+ <div id='x2ead26cf' style='display:none;' class='imgcontainer'>
<div style="max-width:293px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 293.842 147.96">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -6665,8 +6665,8 @@ FROM t1 ORDER BY c, a;
</div>
</div>
<p><b><a href="syntax/join-clause.html">join-clause:</a></b>
-<button id='x09db4fdc' onclick='hideorshow("x09db4fdc","xf6525aa6")'>show</button></p>
- <div id='xf6525aa6' style='display:none;' class='imgcontainer'>
+<button id='xdda04908' onclick='hideorshow("xdda04908","x93f8cd90")'>show</button></p>
+ <div id='x93f8cd90' style='display:none;' class='imgcontainer'>
<div style="max-width:793px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 793.282 84.24">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -6697,8 +6697,8 @@ FROM t1 ORDER BY c, a;
</svg>
</div>
<p><b><a href="syntax/join-constraint.html">join-constraint:</a></b>
-<button id='xf5b07b14' onclick='hideorshow("xf5b07b14","x7d470f23")'>show</button></p>
- <div id='x7d470f23' style='display:none;' class='imgcontainer'>
+<button id='x35740004' onclick='hideorshow("x35740004","x414583c7")'>show</button></p>
+ <div id='x414583c7' style='display:none;' class='imgcontainer'>
<div style="max-width:483px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 483.336 126.576">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,55 39,59 39,50" style="fill:rgb(0,0,0)"/>
@@ -6745,8 +6745,8 @@ FROM t1 ORDER BY c, a;
</div>
</div>
<p><b><a href="syntax/join-operator.html">join-operator:</a></b>
-<button id='x1f8f067e' onclick='hideorshow("x1f8f067e","x77621cba")'>show</button></p>
- <div id='x77621cba' style='display:none;' class='imgcontainer'>
+<button id='x0dcd7060' onclick='hideorshow("x0dcd7060","x90198d7e")'>show</button></p>
+ <div id='x90198d7e' style='display:none;' class='imgcontainer'>
<div style="max-width:620px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 620.333 255.312">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,71 39,76 39,67" style="fill:rgb(0,0,0)"/>
@@ -6813,8 +6813,8 @@ FROM t1 ORDER BY c, a;
</div>
</div>
<p><b><a href="syntax/ordering-term.html">ordering-term:</a></b>
-<button id='x2c2d83da' onclick='hideorshow("x2c2d83da","x4f75c28b")'>show</button></p>
- <div id='x4f75c28b' style='display:none;' class='imgcontainer'>
+<button id='x74a61c7c' onclick='hideorshow("x74a61c7c","xd78a941d")'>show</button></p>
+ <div id='xd78a941d' style='display:none;' class='imgcontainer'>
<div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -6874,8 +6874,8 @@ FROM t1 ORDER BY c, a;
</div>
</div>
<p><b><a href="syntax/result-column.html">result-column:</a></b>
-<button id='x9766d8b9' onclick='hideorshow("x9766d8b9","xbe4652fc")'>show</button></p>
- <div id='xbe4652fc' style='display:none;' class='imgcontainer'>
+<button id='x4e7118b7' onclick='hideorshow("x4e7118b7","xd3843625")'>show</button></p>
+ <div id='xd3843625' style='display:none;' class='imgcontainer'>
<div style="max-width:398px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 398.054 163.08">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="45,17 33,21 33,12" style="fill:rgb(0,0,0)"/>
@@ -6927,8 +6927,8 @@ FROM t1 ORDER BY c, a;
</div>
</div>
<p><b><a href="syntax/table-or-subquery.html">table-or-subquery:</a></b>
-<button id='xa37b1d70' onclick='hideorshow("xa37b1d70","xdd371957")'>show</button></p>
- <div id='xdd371957' style='display:none;' class='imgcontainer'>
+<button id='x73838f84' onclick='hideorshow("x73838f84","x71e2799e")'>show</button></p>
+ <div id='x71e2799e' style='display:none;' class='imgcontainer'>
<div style="max-width:720px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 720.778 457.704">
<circle cx="5" cy="36" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,74 39,78 39,70" style="fill:rgb(0,0,0)"/>
@@ -7072,8 +7072,8 @@ FROM t1 ORDER BY c, a;
</div>
</div>
<p><b><a href="syntax/window-defn.html">window-defn:</a></b>
-<button id='x5a375ead' onclick='hideorshow("x5a375ead","x050877ef")'>show</button></p>
- <div id='x050877ef' style='display:none;' class='imgcontainer'>
+<button id='xdc9ba9a7' onclick='hideorshow("xdc9ba9a7","x903a8b75")'>show</button></p>
+ <div id='x903a8b75' style='display:none;' class='imgcontainer'>
<div style="max-width:479px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 479.765 380.592">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
@@ -7153,8 +7153,8 @@ FROM t1 ORDER BY c, a;
</svg>
</div>
<p><b><a href="syntax/frame-spec.html">frame-spec:</a></b>
-<button id='xc09a2f4d' onclick='hideorshow("xc09a2f4d","xea11e11d")'>show</button></p>
- <div id='xea11e11d' style='display:none;' class='imgcontainer'>
+<button id='x27a69ac8' onclick='hideorshow("x27a69ac8","x0837afac")'>show</button></p>
+ <div id='x0837afac' style='display:none;' class='imgcontainer'>
<div style="max-width:1039px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 1039.65 522.72">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,92 39,97 39,88" style="fill:rgb(0,0,0)"/>
@@ -7365,8 +7365,8 @@ FROM t1 ORDER BY c, a;
</div>
</div>
<p><b><a href="syntax/type-name.html">type-name:</a></b>
-<button id='x6fd3d99a' onclick='hideorshow("x6fd3d99a","x5baa1694")'>show</button></p>
- <div id='x5baa1694' style='display:none;' class='imgcontainer'>
+<button id='xf5f7b40b' onclick='hideorshow("xf5f7b40b","x7cdd2b3d")'>show</button></p>
+ <div id='x7cdd2b3d' style='display:none;' class='imgcontainer'>
<div style="max-width:661px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 661.008 110.16">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="45,17 33,21 33,12" style="fill:rgb(0,0,0)"/>
@@ -7420,8 +7420,8 @@ FROM t1 ORDER BY c, a;
</svg>
</div>
<p><b><a href="syntax/signed-number.html">signed-number:</a></b>
-<button id='x725d3852' onclick='hideorshow("x725d3852","xa38da6e2")'>show</button></p>
- <div id='xa38da6e2' style='display:none;' class='imgcontainer'>
+<button id='x6fc5ca4e' onclick='hideorshow("x6fc5ca4e","x1b4a7c7b")'>show</button></p>
+ <div id='x1b4a7c7b' style='display:none;' class='imgcontainer'>
<div style="max-width:292px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 292.013 99.576">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,44 39,48 39,40" style="fill:rgb(0,0,0)"/>
@@ -7932,5 +7932,5 @@ windows function support was extended to include the EXCLUDE clause,
GROUPS frame types, window chaining, and support for
"&lt;expr&gt; PRECEDING" and "&lt;expr&gt; FOLLOWING" boundaries
in RANGE frames.
-</p><p align="center"><small><i>This page last modified on <a href="https://sqlite.org/docsrc/honeypot" id="mtimelink" data-href="https://sqlite.org/docsrc/finfo/pages/windowfunctions.in?m=e661cf1613">2024-04-01 12:41:31</a> UTC </small></i></p>
+</p><p align="center"><small><i>This page last modified on <a href="https://sqlite.org/docsrc/honeypot" id="mtimelink" data-href="https://sqlite.org/docsrc/finfo/pages/windowfunctions.in?m=e544fdba2f">2024-04-16 17:22:18</a> UTC </small></i></p>
generated by cgit v1.2.3 (git 2.39.1) at 2024-11-24 11:38:39 +0000