This is an automated email from the ASF dual-hosted git repository.

github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/datafusion.git


The following commit(s) were added to refs/heads/asf-site by this push:
     new 0865b43f87 Publish built docs triggered by 
eb2b8c07b2f564fbd9046c67de41ac4ebfe7ae84
0865b43f87 is described below

commit 0865b43f871c6bf1fbb773f7fcbee371a2b5b53f
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Mon Aug 4 19:44:43 2025 +0000

    Publish built docs triggered by eb2b8c07b2f564fbd9046c67de41ac4ebfe7ae84
---
 _sources/user-guide/sql/window_functions.md.txt |   2 +
 searchindex.js                                  |   2 +-
 user-guide/sql/index.html                       |   3 +
 user-guide/sql/window_functions.html            | 440 ++++++++++++------------
 4 files changed, 234 insertions(+), 213 deletions(-)

diff --git a/_sources/user-guide/sql/window_functions.md.txt 
b/_sources/user-guide/sql/window_functions.md.txt
index 73e9731cdb..dc06f3d051 100644
--- a/_sources/user-guide/sql/window_functions.md.txt
+++ b/_sources/user-guide/sql/window_functions.md.txt
@@ -331,6 +331,8 @@ FROM employees;
 +-------------+--------+---------+
 ```
 
+#
+
 ## Analytical Functions
 
 - [first_value](#first_value)
diff --git a/searchindex.js b/searchindex.js
index 6eb90e72ac..9254e3d53d 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles":{"!=":[[56,"op-neq"]],"!~":[[56,"op-re-not-match"]],"!~*":[[56,"op-re-not-match-i"]],"!~~":[[56,"id19"]],"!~~*":[[56,"id20"]],"#":[[56,"op-bit-xor"]],"%":[[56,"op-modulo"]],"&":[[56,"op-bit-and"]],"(relation,
 name) tuples in logical fields and logical columns are 
unique":[[12,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[56,"op-multiply"]],"+":[[56,"op-plus"]],"-":[[56,"op-minus"]],"/":[[56,"op-divide"]],"<":[[56,"op-lt"]],"<
 [...]
\ No newline at end of file
+Search.setIndex({"alltitles":{"":[[62,"id6"]],"!=":[[56,"op-neq"]],"!~":[[56,"op-re-not-match"]],"!~*":[[56,"op-re-not-match-i"]],"!~~":[[56,"id19"]],"!~~*":[[56,"id20"]],"#":[[56,"op-bit-xor"]],"%":[[56,"op-modulo"]],"&":[[56,"op-bit-and"]],"(relation,
 name) tuples in logical fields and logical columns are 
unique":[[12,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[56,"op-multiply"]],"+":[[56,"op-plus"]],"-":[[56,"op-minus"]],"/":[[56,"op-divide"]],"<":[
 [...]
\ No newline at end of file
diff --git a/user-guide/sql/index.html b/user-guide/sql/index.html
index 05b54ec21e..85846e2ed1 100644
--- a/user-guide/sql/index.html
+++ b/user-guide/sql/index.html
@@ -652,6 +652,9 @@
 <li class="toctree-l2"><a class="reference internal" 
href="window_functions.html#syntax">Syntax</a></li>
 <li class="toctree-l2"><a class="reference internal" 
href="window_functions.html#aggregate-functions">Aggregate functions</a></li>
 <li class="toctree-l2"><a class="reference internal" 
href="window_functions.html#ranking-functions">Ranking Functions</a></li>
+</ul>
+</li>
+<li class="toctree-l1"><a class="reference internal" 
href="window_functions.html#id6"></a><ul>
 <li class="toctree-l2"><a class="reference internal" 
href="window_functions.html#analytical-functions">Analytical Functions</a></li>
 </ul>
 </li>
diff --git a/user-guide/sql/window_functions.html 
b/user-guide/sql/window_functions.html
index 659ab00122..f7173208e8 100644
--- a/user-guide/sql/window_functions.html
+++ b/user-guide/sql/window_functions.html
@@ -544,231 +544,244 @@
 
 <nav id="bd-toc-nav">
     <ul class="visible nav section-nav flex-column">
- <li class="toc-h2 nav-item toc-entry">
-  <a class="reference internal nav-link" href="#syntax">
-   Syntax
+ <li class="toc-h1 nav-item toc-entry">
+  <a class="reference internal nav-link" href="#">
+   Window Functions
   </a>
- </li>
- <li class="toc-h2 nav-item toc-entry">
-  <a class="reference internal nav-link" href="#aggregate-functions">
-   Aggregate functions
-  </a>
- </li>
- <li class="toc-h2 nav-item toc-entry">
-  <a class="reference internal nav-link" href="#ranking-functions">
-   Ranking Functions
-  </a>
-  <ul class="nav section-nav flex-column">
-   <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#cume-dist">
-     <code class="docutils literal notranslate">
-      <span class="pre">
-       cume_dist
-      </span>
-     </code>
+  <ul class="visible nav section-nav flex-column">
+   <li class="toc-h2 nav-item toc-entry">
+    <a class="reference internal nav-link" href="#syntax">
+     Syntax
     </a>
-    <ul class="nav section-nav flex-column">
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#example">
-       Example
-      </a>
-     </li>
-    </ul>
    </li>
-   <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#dense-rank">
-     <code class="docutils literal notranslate">
-      <span class="pre">
-       dense_rank
-      </span>
-     </code>
+   <li class="toc-h2 nav-item toc-entry">
+    <a class="reference internal nav-link" href="#aggregate-functions">
+     Aggregate functions
     </a>
-    <ul class="nav section-nav flex-column">
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id1">
-       Example
-      </a>
-     </li>
-    </ul>
    </li>
-   <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#ntile">
-     <code class="docutils literal notranslate">
-      <span class="pre">
-       ntile
-      </span>
-     </code>
+   <li class="toc-h2 nav-item toc-entry">
+    <a class="reference internal nav-link" href="#ranking-functions">
+     Ranking Functions
     </a>
     <ul class="nav section-nav flex-column">
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#arguments">
-       Arguments
+     <li class="toc-h3 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#cume-dist">
+       <code class="docutils literal notranslate">
+        <span class="pre">
+         cume_dist
+        </span>
+       </code>
       </a>
+      <ul class="nav section-nav flex-column">
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#example">
+         Example
+        </a>
+       </li>
+      </ul>
      </li>
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id2">
-       Example
+     <li class="toc-h3 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#dense-rank">
+       <code class="docutils literal notranslate">
+        <span class="pre">
+         dense_rank
+        </span>
+       </code>
       </a>
+      <ul class="nav section-nav flex-column">
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#id1">
+         Example
+        </a>
+       </li>
+      </ul>
      </li>
-    </ul>
-   </li>
-   <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#percent-rank">
-     <code class="docutils literal notranslate">
-      <span class="pre">
-       percent_rank
-      </span>
-     </code>
-    </a>
-    <ul class="nav section-nav flex-column">
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id3">
-       Example
+     <li class="toc-h3 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#ntile">
+       <code class="docutils literal notranslate">
+        <span class="pre">
+         ntile
+        </span>
+       </code>
       </a>
+      <ul class="nav section-nav flex-column">
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#arguments">
+         Arguments
+        </a>
+       </li>
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#id2">
+         Example
+        </a>
+       </li>
+      </ul>
      </li>
-    </ul>
-   </li>
-   <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#rank">
-     <code class="docutils literal notranslate">
-      <span class="pre">
-       rank
-      </span>
-     </code>
-    </a>
-    <ul class="nav section-nav flex-column">
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id4">
-       Example
+     <li class="toc-h3 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#percent-rank">
+       <code class="docutils literal notranslate">
+        <span class="pre">
+         percent_rank
+        </span>
+       </code>
       </a>
+      <ul class="nav section-nav flex-column">
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#id3">
+         Example
+        </a>
+       </li>
+      </ul>
      </li>
-    </ul>
-   </li>
-   <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#row-number">
-     <code class="docutils literal notranslate">
-      <span class="pre">
-       row_number
-      </span>
-     </code>
-    </a>
-    <ul class="nav section-nav flex-column">
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id5">
-       Example
+     <li class="toc-h3 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#rank">
+       <code class="docutils literal notranslate">
+        <span class="pre">
+         rank
+        </span>
+       </code>
       </a>
+      <ul class="nav section-nav flex-column">
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#id4">
+         Example
+        </a>
+       </li>
+      </ul>
+     </li>
+     <li class="toc-h3 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#row-number">
+       <code class="docutils literal notranslate">
+        <span class="pre">
+         row_number
+        </span>
+       </code>
+      </a>
+      <ul class="nav section-nav flex-column">
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#id5">
+         Example
+        </a>
+       </li>
+      </ul>
      </li>
     </ul>
    </li>
   </ul>
  </li>
- <li class="toc-h2 nav-item toc-entry">
-  <a class="reference internal nav-link" href="#analytical-functions">
-   Analytical Functions
+ <li class="toc-h1 nav-item toc-entry">
+  <a class="reference internal nav-link" href="#id6">
   </a>
-  <ul class="nav section-nav flex-column">
-   <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#first-value">
-     <code class="docutils literal notranslate">
-      <span class="pre">
-       first_value
-      </span>
-     </code>
+  <ul class="visible nav section-nav flex-column">
+   <li class="toc-h2 nav-item toc-entry">
+    <a class="reference internal nav-link" href="#analytical-functions">
+     Analytical Functions
     </a>
     <ul class="nav section-nav flex-column">
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id6">
-       Arguments
-      </a>
-     </li>
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id7">
-       Example
+     <li class="toc-h3 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#first-value">
+       <code class="docutils literal notranslate">
+        <span class="pre">
+         first_value
+        </span>
+       </code>
       </a>
+      <ul class="nav section-nav flex-column">
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#id7">
+         Arguments
+        </a>
+       </li>
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#id8">
+         Example
+        </a>
+       </li>
+      </ul>
      </li>
-    </ul>
-   </li>
-   <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#lag">
-     <code class="docutils literal notranslate">
-      <span class="pre">
-       lag
-      </span>
-     </code>
-    </a>
-    <ul class="nav section-nav flex-column">
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id8">
-       Arguments
+     <li class="toc-h3 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#lag">
+       <code class="docutils literal notranslate">
+        <span class="pre">
+         lag
+        </span>
+       </code>
       </a>
+      <ul class="nav section-nav flex-column">
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#id9">
+         Arguments
+        </a>
+       </li>
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#id10">
+         Example
+        </a>
+       </li>
+      </ul>
      </li>
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id9">
-       Example
+     <li class="toc-h3 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#last-value">
+       <code class="docutils literal notranslate">
+        <span class="pre">
+         last_value
+        </span>
+       </code>
       </a>
+      <ul class="nav section-nav flex-column">
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#id11">
+         Arguments
+        </a>
+       </li>
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#id12">
+         Example
+        </a>
+       </li>
+      </ul>
      </li>
-    </ul>
-   </li>
-   <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#last-value">
-     <code class="docutils literal notranslate">
-      <span class="pre">
-       last_value
-      </span>
-     </code>
-    </a>
-    <ul class="nav section-nav flex-column">
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id10">
-       Arguments
+     <li class="toc-h3 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#lead">
+       <code class="docutils literal notranslate">
+        <span class="pre">
+         lead
+        </span>
+       </code>
       </a>
+      <ul class="nav section-nav flex-column">
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#id13">
+         Arguments
+        </a>
+       </li>
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#id14">
+         Example
+        </a>
+       </li>
+      </ul>
      </li>
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id11">
-       Example
-      </a>
-     </li>
-    </ul>
-   </li>
-   <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#lead">
-     <code class="docutils literal notranslate">
-      <span class="pre">
-       lead
-      </span>
-     </code>
-    </a>
-    <ul class="nav section-nav flex-column">
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id12">
-       Arguments
-      </a>
-     </li>
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id13">
-       Example
-      </a>
-     </li>
-    </ul>
-   </li>
-   <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#nth-value">
-     <code class="docutils literal notranslate">
-      <span class="pre">
-       nth_value
-      </span>
-     </code>
-    </a>
-    <ul class="nav section-nav flex-column">
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id14">
-       Arguments
-      </a>
-     </li>
-     <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id15">
-       Example
+     <li class="toc-h3 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#nth-value">
+       <code class="docutils literal notranslate">
+        <span class="pre">
+         nth_value
+        </span>
+       </code>
       </a>
+      <ul class="nav section-nav flex-column">
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#id15">
+         Arguments
+        </a>
+       </li>
+       <li class="toc-h4 nav-item toc-entry">
+        <a class="reference internal nav-link" href="#id16">
+         Example
+        </a>
+       </li>
+      </ul>
      </li>
     </ul>
    </li>
@@ -1114,6 +1127,9 @@ Instead, the rows retain their separate identities. 
Behind the scenes, the windo
 </section>
 </section>
 </section>
+</section>
+<section id="id6">
+<h1><a class="headerlink" href="#id6" title="Link to this heading">¶</a></h1>
 <section id="analytical-functions">
 <h2>Analytical Functions<a class="headerlink" href="#analytical-functions" 
title="Link to this heading">¶</a></h2>
 <ul class="simple">
@@ -1129,14 +1145,14 @@ Instead, the rows retain their separate identities. 
Behind the scenes, the windo
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="n">first_value</span><span 
class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id6">
-<h4>Arguments<a class="headerlink" href="#id6" title="Link to this 
heading">¶</a></h4>
+<section id="id7">
+<h4>Arguments<a class="headerlink" href="#id7" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: Expression to operate on</p></li>
 </ul>
 </section>
-<section id="id7">
-<h4>Example<a class="headerlink" href="#id7" title="Link to this 
heading">¶</a></h4>
+<section id="id8">
+<h4>Example<a class="headerlink" href="#id8" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="c1">-- Example usage of the 
first_value window function:</span>
 <span class="k">SELECT</span><span class="w"> </span><span 
class="n">department</span><span class="p">,</span>
 <span class="w">  </span><span class="n">employee_id</span><span 
class="p">,</span>
@@ -1163,16 +1179,16 @@ Instead, the rows retain their separate identities. 
Behind the scenes, the windo
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="n">lag</span><span 
class="p">(</span><span class="n">expression</span><span 
class="p">,</span><span class="w"> </span><span class="k">offset</span><span 
class="p">,</span><span class="w"> </span><span class="k">default</span><span 
class="p">)</span>
 </pre></div>
 </div>
-<section id="id8">
-<h4>Arguments<a class="headerlink" href="#id8" title="Link to this 
heading">¶</a></h4>
+<section id="id9">
+<h4>Arguments<a class="headerlink" href="#id9" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: Expression to operate on</p></li>
 <li><p><strong>offset</strong>: Integer. Specifies how many rows back the 
value of expression should be retrieved. Defaults to 1.</p></li>
 <li><p><strong>default</strong>: The default value if the offset is not within 
the partition. Must be of the same type as expression.</p></li>
 </ul>
 </section>
-<section id="id9">
-<h4>Example<a class="headerlink" href="#id9" title="Link to this 
heading">¶</a></h4>
+<section id="id10">
+<h4>Example<a class="headerlink" href="#id10" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="c1">-- Example usage of the 
lag window function:</span>
 <span class="k">SELECT</span><span class="w"> </span><span 
class="n">employee_id</span><span class="p">,</span>
 <span class="w">    </span><span class="n">salary</span><span 
class="p">,</span>
@@ -1197,14 +1213,14 @@ Instead, the rows retain their separate identities. 
Behind the scenes, the windo
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="n">last_value</span><span 
class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id10">
-<h4>Arguments<a class="headerlink" href="#id10" title="Link to this 
heading">¶</a></h4>
+<section id="id11">
+<h4>Arguments<a class="headerlink" href="#id11" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: Expression to operate on</p></li>
 </ul>
 </section>
-<section id="id11">
-<h4>Example<a class="headerlink" href="#id11" title="Link to this 
heading">¶</a></h4>
+<section id="id12">
+<h4>Example<a class="headerlink" href="#id12" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="c1">-- SQL example of 
last_value:</span>
 <span class="k">SELECT</span><span class="w"> </span><span 
class="n">department</span><span class="p">,</span>
 <span class="w">       </span><span class="n">employee_id</span><span 
class="p">,</span>
@@ -1231,16 +1247,16 @@ Instead, the rows retain their separate identities. 
Behind the scenes, the windo
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="n">lead</span><span 
class="p">(</span><span class="n">expression</span><span 
class="p">,</span><span class="w"> </span><span class="k">offset</span><span 
class="p">,</span><span class="w"> </span><span class="k">default</span><span 
class="p">)</span>
 </pre></div>
 </div>
-<section id="id12">
-<h4>Arguments<a class="headerlink" href="#id12" title="Link to this 
heading">¶</a></h4>
+<section id="id13">
+<h4>Arguments<a class="headerlink" href="#id13" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: Expression to operate on</p></li>
 <li><p><strong>offset</strong>: Integer. Specifies how many rows forward the 
value of expression should be retrieved. Defaults to 1.</p></li>
 <li><p><strong>default</strong>: The default value if the offset is not within 
the partition. Must be of the same type as expression.</p></li>
 </ul>
 </section>
-<section id="id13">
-<h4>Example<a class="headerlink" href="#id13" title="Link to this 
heading">¶</a></h4>
+<section id="id14">
+<h4>Example<a class="headerlink" href="#id14" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="c1">-- Example usage of lead 
window function:</span>
 <span class="k">SELECT</span>
 <span class="w">    </span><span class="n">employee_id</span><span 
class="p">,</span>
@@ -1268,15 +1284,15 @@ Instead, the rows retain their separate identities. 
Behind the scenes, the windo
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="n">nth_value</span><span 
class="p">(</span><span class="n">expression</span><span 
class="p">,</span><span class="w"> </span><span class="n">n</span><span 
class="p">)</span>
 </pre></div>
 </div>
-<section id="id14">
-<h4>Arguments<a class="headerlink" href="#id14" title="Link to this 
heading">¶</a></h4>
+<section id="id15">
+<h4>Arguments<a class="headerlink" href="#id15" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: The column from which to retrieve the nth 
value.</p></li>
 <li><p><strong>n</strong>: Integer. Specifies the row number (starting from 1) 
in the window frame.</p></li>
 </ul>
 </section>
-<section id="id15">
-<h4>Example<a class="headerlink" href="#id15" title="Link to this 
heading">¶</a></h4>
+<section id="id16">
+<h4>Example<a class="headerlink" href="#id16" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-sql notranslate"><div 
class="highlight"><pre><span></span><span class="c1">-- Sample employees 
table:</span>
 <span class="k">CREATE</span><span class="w"> </span><span 
class="k">TABLE</span><span class="w"> </span><span 
class="n">employees</span><span class="w"> </span><span class="p">(</span><span 
class="n">id</span><span class="w"> </span><span class="nb">INT</span><span 
class="p">,</span><span class="w"> </span><span class="n">salary</span><span 
class="w"> </span><span class="nb">INT</span><span class="p">);</span>
 <span class="k">INSERT</span><span class="w"> </span><span 
class="k">INTO</span><span class="w"> </span><span 
class="n">employees</span><span class="w"> </span><span class="p">(</span><span 
class="n">id</span><span class="p">,</span><span class="w"> </span><span 
class="n">salary</span><span class="p">)</span><span class="w"> </span><span 
class="k">VALUES</span>


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@datafusion.apache.org
For additional commands, e-mail: commits-h...@datafusion.apache.org

Reply via email to