This is an automated email from the ASF dual-hosted git repository.
github-actions[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 c6af2e42f2 Publish built docs triggered by
67947b6b90c891843eb167da2fd3e562587834c1
c6af2e42f2 is described below
commit c6af2e42f2c766a166bec6c52a064a53d5eb5c54
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Sat Jul 18 13:43:39 2026 +0000
Publish built docs triggered by 67947b6b90c891843eb167da2fd3e562587834c1
---
_sources/user-guide/sql/aggregate_functions.md.txt | 24 ++
searchindex.js | 2 +-
user-guide/sql/aggregate_functions.html | 452 +++++++++++----------
3 files changed, 266 insertions(+), 212 deletions(-)
diff --git a/_sources/user-guide/sql/aggregate_functions.md.txt
b/_sources/user-guide/sql/aggregate_functions.md.txt
index ba9c6ae124..c681ccb28e 100644
--- a/_sources/user-guide/sql/aggregate_functions.md.txt
+++ b/_sources/user-guide/sql/aggregate_functions.md.txt
@@ -80,6 +80,7 @@ SELECT SUM(x) WITHIN GROUP (ORDER BY x) FROM t;
## General Functions
+- [any_value](#any_value)
- [array_agg](#array_agg)
- [avg](#avg)
- [bit_and](#bit_and)
@@ -105,6 +106,29 @@ SELECT SUM(x) WITHIN GROUP (ORDER BY x) FROM t;
- [var_samp](#var_samp)
- [var_sample](#var_sample)
+### `any_value`
+
+Returns an arbitrary non-null value from a group, or NULL if the group
contains only NULL values.
+
+```sql
+any_value(expression)
+```
+
+#### Arguments
+
+- **expression**: The expression to operate on. Can be a constant, column, or
function, and any combination of operators.
+
+#### Example
+
+```sql
+> SELECT any_value(column_name) FROM table_name;
++------------------------+
+| any_value(column_name) |
++------------------------+
+| arbitrary_value |
++------------------------+
+```
+
### `array_agg`
Returns an array created from the expression elements. If ordering is
required, elements are inserted in the specified order.
diff --git a/searchindex.js b/searchindex.js
index 75ac0005d0..a2d871d301 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles":{"!=":[[74,"op-neq"]],"!~":[[74,"op-re-not-match"]],"!~*":[[74,"op-re-not-match-i"]],"!~~":[[74,"id19"]],"!~~*":[[74,"id20"]],"#":[[74,"op-bit-xor"]],"%":[[74,"op-modulo"]],"&":[[74,"op-bit-and"]],"(relation,
name) tuples in logical fields and logical columns are
unique":[[15,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[74,"op-multiply"]],"+":[[74,"op-plus"]],"-":[[74,"op-minus"]],"/":[[74,"op-divide"]],"1.
Array Literal Con [...]
\ No newline at end of file
+Search.setIndex({"alltitles":{"!=":[[74,"op-neq"]],"!~":[[74,"op-re-not-match"]],"!~*":[[74,"op-re-not-match-i"]],"!~~":[[74,"id19"]],"!~~*":[[74,"id20"]],"#":[[74,"op-bit-xor"]],"%":[[74,"op-modulo"]],"&":[[74,"op-bit-and"]],"(relation,
name) tuples in logical fields and logical columns are
unique":[[15,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[74,"op-multiply"]],"+":[[74,"op-plus"]],"-":[[74,"op-minus"]],"/":[[74,"op-divide"]],"1.
Array Literal Con [...]
\ No newline at end of file
diff --git a/user-guide/sql/aggregate_functions.html
b/user-guide/sql/aggregate_functions.html
index c522c8823d..4590d34e3c 100644
--- a/user-guide/sql/aggregate_functions.html
+++ b/user-guide/sql/aggregate_functions.html
@@ -497,6 +497,7 @@ use the <code class="docutils literal notranslate"><span
class="pre">OVER</span>
<section id="general-functions">
<h2>General Functions<a class="headerlink" href="#general-functions"
title="Link to this heading">#</a></h2>
<ul class="simple">
+<li><p><a class="reference internal" href="#any-value">any_value</a></p></li>
<li><p><a class="reference internal" href="#array-agg">array_agg</a></p></li>
<li><p><a class="reference internal" href="#avg">avg</a></p></li>
<li><p><a class="reference internal" href="#bit-and">bit_and</a></p></li>
@@ -522,6 +523,30 @@ use the <code class="docutils literal notranslate"><span
class="pre">OVER</span>
<li><p><a class="reference internal" href="#var-samp">var_samp</a></p></li>
<li><p><a class="reference internal" href="#var-sample">var_sample</a></p></li>
</ul>
+<section id="any-value">
+<h3><code class="docutils literal notranslate"><span
class="pre">any_value</span></code><a class="headerlink" href="#any-value"
title="Link to this heading">#</a></h3>
+<p>Returns an arbitrary non-null value from a group, or NULL if the group
contains only NULL values.</p>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">any_value</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="arguments">
+<h4>Arguments<a class="headerlink" href="#arguments" title="Link to this
heading">#</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
+</ul>
+</section>
+<section id="example">
+<h4>Example<a class="headerlink" href="#example" title="Link to this
heading">#</a></h4>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">any_value</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">any_value</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
+<span class="o">+</span><span class="c1">------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">arbitrary_value</span><span class="w"> </span><span
class="o">|</span>
+<span class="o">+</span><span class="c1">------------------------+</span>
+</pre></div>
+</div>
+</section>
+</section>
<section id="array-agg">
<h3><code class="docutils literal notranslate"><span
class="pre">array_agg</span></code><a class="headerlink" href="#array-agg"
title="Link to this heading">#</a></h3>
<p>Returns an array created from the expression elements. If ordering is
required, elements are inserted in the specified order.
@@ -529,14 +554,14 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">array_agg</span><span
class="p">(</span><span class="n">expression</span><span class="w">
</span><span class="p">[</span><span class="k">ORDER</span><span class="w">
</span><span class="k">BY</span><span class="w"> </span><span
class="n">expression</span><span class="p">])</span>
</pre></div>
</div>
-<section id="arguments">
-<h4>Arguments<a class="headerlink" href="#arguments" title="Link to this
heading">#</a></h4>
+<section id="id1">
+<h4>Arguments<a class="headerlink" href="#id1" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="example">
-<h4>Example<a class="headerlink" href="#example" title="Link to this
heading">#</a></h4>
+<section id="id2">
+<h4>Example<a class="headerlink" href="#id2" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">array_agg</span><span class="p">(</span><span
class="k">column_name</span><span class="w"> </span><span
class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span
class="w"> </span><span class="n">other_column</span><span
class="p">)</span><span class="w"> </span><span clas [...]
<span class="o">+</span><span
class="c1">-----------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">array_agg</span><span class="p">(</span><span
class="k">column_name</span><span class="w"> </span><span
class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span
class="w"> </span><span class="n">other_column</span><span
class="p">)</span><span class="w"> </span><span class="o">|</span>
@@ -559,14 +584,14 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">avg</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id1">
-<h4>Arguments<a class="headerlink" href="#id1" title="Link to this
heading">#</a></h4>
+<section id="id3">
+<h4>Arguments<a class="headerlink" href="#id3" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id2">
-<h4>Example<a class="headerlink" href="#id2" title="Link to this
heading">#</a></h4>
+<section id="id4">
+<h4>Example<a class="headerlink" href="#id4" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="k">avg</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="k">avg</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -589,8 +614,8 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">bit_and</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id3">
-<h4>Arguments<a class="headerlink" href="#id3" title="Link to this
heading">#</a></h4>
+<section id="id5">
+<h4>Arguments<a class="headerlink" href="#id5" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Integer expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
@@ -602,8 +627,8 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">bit_or</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id4">
-<h4>Arguments<a class="headerlink" href="#id4" title="Link to this
heading">#</a></h4>
+<section id="id6">
+<h4>Arguments<a class="headerlink" href="#id6" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Integer expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
@@ -615,8 +640,8 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">bit_xor</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id5">
-<h4>Arguments<a class="headerlink" href="#id5" 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>: Integer expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
@@ -628,14 +653,14 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">bool_and</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="id8">
+<h4>Arguments<a class="headerlink" href="#id8" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id7">
-<h4>Example<a class="headerlink" href="#id7" title="Link to this
heading">#</a></h4>
+<section id="id9">
+<h4>Example<a class="headerlink" href="#id9" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">bool_and</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">bool_and</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -652,14 +677,14 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">bool_and</span><span
class="p">(</span><span class="n">expression</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="id10">
+<h4>Arguments<a class="headerlink" href="#id10" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id9">
-<h4>Example<a class="headerlink" href="#id9" title="Link to this
heading">#</a></h4>
+<section id="id11">
+<h4>Example<a class="headerlink" href="#id11" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">bool_and</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">bool_and</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -676,14 +701,14 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">count</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="id12">
+<h4>Arguments<a class="headerlink" href="#id12" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id11">
-<h4>Example<a class="headerlink" href="#id11" title="Link to this
heading">#</a></h4>
+<section id="id13">
+<h4>Example<a class="headerlink" href="#id13" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="k">count</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span class="c1">-----------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="k">count</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -707,14 +732,14 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<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="w">
</span><span class="p">[</span><span class="k">ORDER</span><span class="w">
</span><span class="k">BY</span><span class="w"> </span><span
class="n">expression</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="id14">
+<h4>Arguments<a class="headerlink" href="#id14" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id13">
-<h4>Example<a class="headerlink" href="#id13" title="Link to this
heading">#</a></h4>
+<section id="id15">
+<h4>Example<a class="headerlink" href="#id15" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">first_value</span><span class="p">(</span><span
class="k">column_name</span><span class="w"> </span><span
class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span
class="w"> </span><span class="n">other_column</span><span
class="p">)</span><span class="w"> </span><span cl [...]
<span class="o">+</span><span
class="c1">-----------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">first_value</span><span class="p">(</span><span
class="k">column_name</span><span class="w"> </span><span
class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span
class="w"> </span><span class="n">other_column</span><span
class="p">)</span><span class="o">|</span>
@@ -731,14 +756,14 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">grouping</span><span
class="p">(</span><span class="n">expression</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="id16">
+<h4>Arguments<a class="headerlink" href="#id16" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to evaluate whether data is
aggregated across the specified column. Can be a constant, column, or
function.</p></li>
</ul>
</section>
-<section id="id15">
-<h4>Example<a class="headerlink" href="#id15" title="Link to this
heading">#</a></h4>
+<section id="id17">
+<h4>Example<a class="headerlink" href="#id17" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="k">column_name</span><span class="p">,</span><span class="w">
</span><span class="k">GROUPING</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">AS</span><span class="w"> </span><span
class="n">group_column</span>
<span class="w"> </span><span class="k">FROM</span><span class="w">
</span><span class="k">table_name</span>
<span class="w"> </span><span class="k">GROUP</span><span class="w">
</span><span class="k">BY</span><span class="w"> </span><span
class="k">GROUPING</span><span class="w"> </span><span
class="k">SETS</span><span class="w"> </span><span class="p">((</span><span
class="k">column_name</span><span class="p">),</span><span class="w">
</span><span class="p">());</span>
@@ -759,14 +784,14 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<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="w">
</span><span class="p">[</span><span class="k">ORDER</span><span class="w">
</span><span class="k">BY</span><span class="w"> </span><span
class="n">expression</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id16">
-<h4>Arguments<a class="headerlink" href="#id16" title="Link to this
heading">#</a></h4>
+<section id="id18">
+<h4>Arguments<a class="headerlink" href="#id18" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id17">
-<h4>Example<a class="headerlink" href="#id17" title="Link to this
heading">#</a></h4>
+<section id="id19">
+<h4>Example<a class="headerlink" href="#id19" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">last_value</span><span class="p">(</span><span
class="k">column_name</span><span class="w"> </span><span
class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span
class="w"> </span><span class="n">other_column</span><span
class="p">)</span><span class="w"> </span><span cla [...]
<span class="o">+</span><span
class="c1">-----------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">last_value</span><span class="p">(</span><span
class="k">column_name</span><span class="w"> </span><span
class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span
class="w"> </span><span class="n">other_column</span><span
class="p">)</span><span class="w"> </span><span class="o">|</span>
@@ -783,14 +808,14 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">max</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id18">
-<h4>Arguments<a class="headerlink" href="#id18" title="Link to this
heading">#</a></h4>
+<section id="id20">
+<h4>Arguments<a class="headerlink" href="#id20" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id19">
-<h4>Example<a class="headerlink" href="#id19" title="Link to this
heading">#</a></h4>
+<section id="id21">
+<h4>Example<a class="headerlink" href="#id21" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="k">max</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="k">max</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -811,14 +836,14 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">median</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id20">
-<h4>Arguments<a class="headerlink" href="#id20" title="Link to this
heading">#</a></h4>
+<section id="id22">
+<h4>Arguments<a class="headerlink" href="#id22" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id21">
-<h4>Example<a class="headerlink" href="#id21" title="Link to this
heading">#</a></h4>
+<section id="id23">
+<h4>Example<a class="headerlink" href="#id23" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">median</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">median</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -835,14 +860,14 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">min</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id22">
-<h4>Arguments<a class="headerlink" href="#id22" title="Link to this
heading">#</a></h4>
+<section id="id24">
+<h4>Arguments<a class="headerlink" href="#id24" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id23">
-<h4>Example<a class="headerlink" href="#id23" title="Link to this
heading">#</a></h4>
+<section id="id25">
+<h4>Example<a class="headerlink" href="#id25" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="k">min</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="k">min</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -859,15 +884,15 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">percentile_cont</span><span
class="p">(</span><span class="n">percentile</span><span
class="p">)</span><span class="w"> </span><span class="n">WITHIN</span><span
class="w"> </span><span class="k">GROUP</span><span class="w"> </span><span
class="p">(</span><span class="k">ORDER</span><span class="w"> </span><span
class="k">BY</span><span class="w"> </span><span
class="n">expression</span><span [...]
</pre></div>
</div>
-<section id="id24">
-<h4>Arguments<a class="headerlink" href="#id24" title="Link to this
heading">#</a></h4>
+<section id="id26">
+<h4>Arguments<a class="headerlink" href="#id26" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>percentile</strong>: Percentile to compute. Must be a float
value between 0 and 1 (inclusive).</p></li>
</ul>
</section>
-<section id="id25">
-<h4>Example<a class="headerlink" href="#id25" title="Link to this
heading">#</a></h4>
+<section id="id27">
+<h4>Example<a class="headerlink" href="#id27" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">percentile_cont</span><span class="p">(</span><span
class="mi">0</span><span class="p">.</span><span class="mi">75</span><span
class="p">)</span><span class="w"> </span><span class="n">WITHIN</span><span
class="w"> </span><span class="k">GROUP</span><span class="w"> </span><span
class="p">(< [...]
<span class="o">+</span><span
class="c1">----------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">percentile_cont</span><span class="p">(</span><span
class="mi">0</span><span class="p">.</span><span class="mi">75</span><span
class="p">)</span><span class="w"> </span><span class="n">WITHIN</span><span
class="w"> </span><span class="k">GROUP</span><span class="w"> </span><span
class="p">(</span><span class="k">ORDER</span><span class="w"> </span><span
class="k">BY</span><span class="w"> </span><span class="k">column_name</ [...]
@@ -886,8 +911,8 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
</pre></div>
</div>
</section>
-<section id="id26">
-<h4>Aliases<a class="headerlink" href="#id26" title="Link to this
heading">#</a></h4>
+<section id="id28">
+<h4>Aliases<a class="headerlink" href="#id28" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p>quantile_cont</p></li>
</ul>
@@ -903,15 +928,15 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">string_agg</span><span
class="p">([</span><span class="k">DISTINCT</span><span class="p">]</span><span
class="w"> </span><span class="n">expression</span><span
class="p">,</span><span class="w"> </span><span class="k">delimiter</span><span
class="w"> </span><span class="p">[</span><span class="k">ORDER</span><span
class="w"> </span><span class="k">BY</span><span class="w"> </span><span
class=" [...]
</pre></div>
</div>
-<section id="id27">
-<h4>Arguments<a class="headerlink" href="#id27" title="Link to this
heading">#</a></h4>
+<section id="id29">
+<h4>Arguments<a class="headerlink" href="#id29" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The string expression to concatenate. Can
be a column or any valid string expression.</p></li>
<li><p><strong>delimiter</strong>: A literal string used as a separator
between the concatenated values.</p></li>
</ul>
</section>
-<section id="id28">
-<h4>Example<a class="headerlink" href="#id28" title="Link to this
heading">#</a></h4>
+<section id="id30">
+<h4>Example<a class="headerlink" href="#id30" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">string_agg</span><span class="p">(</span><span
class="n">name</span><span class="p">,</span><span class="w"> </span><span
class="s1">', '</span><span class="p">)</span><span class="w">
</span><span class="k">AS</span><span class="w"> </span><span
class="n">names_list</span>
<span class="w"> </span><span class="k">FROM</span><span class="w">
</span><span class="n">employee</span><span class="p">;</span>
<span class="o">+</span><span class="c1">--------------------------+</span>
@@ -943,14 +968,14 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">sum</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id29">
-<h4>Arguments<a class="headerlink" href="#id29" title="Link to this
heading">#</a></h4>
+<section id="id31">
+<h4>Arguments<a class="headerlink" href="#id31" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id30">
-<h4>Example<a class="headerlink" href="#id30" title="Link to this
heading">#</a></h4>
+<section id="id32">
+<h4>Example<a class="headerlink" href="#id32" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="k">sum</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span class="c1">-----------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="k">sum</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -967,14 +992,14 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">var</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id31">
-<h4>Arguments<a class="headerlink" href="#id31" title="Link to this
heading">#</a></h4>
+<section id="id33">
+<h4>Arguments<a class="headerlink" href="#id33" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Numeric expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id32">
-<h4>Aliases<a class="headerlink" href="#id32" title="Link to this
heading">#</a></h4>
+<section id="id34">
+<h4>Aliases<a class="headerlink" href="#id34" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p>var_sample</p></li>
<li><p>var_samp</p></li>
@@ -987,14 +1012,14 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">var_pop</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id33">
-<h4>Arguments<a class="headerlink" href="#id33" title="Link to this
heading">#</a></h4>
+<section id="id35">
+<h4>Arguments<a class="headerlink" href="#id35" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Numeric expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id34">
-<h4>Aliases<a class="headerlink" href="#id34" title="Link to this
heading">#</a></h4>
+<section id="id36">
+<h4>Aliases<a class="headerlink" href="#id36" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p>var_population</p></li>
</ul>
@@ -1040,15 +1065,15 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">corr</span><span
class="p">(</span><span class="n">expression1</span><span
class="p">,</span><span class="w"> </span><span
class="n">expression2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id35">
-<h4>Arguments<a class="headerlink" href="#id35" title="Link to this
heading">#</a></h4>
+<section id="id37">
+<h4>Arguments<a class="headerlink" href="#id37" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: First expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>expression2</strong>: Second expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id36">
-<h4>Example<a class="headerlink" href="#id36" title="Link to this
heading">#</a></h4>
+<section id="id38">
+<h4>Example<a class="headerlink" href="#id38" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">corr</span><span class="p">(</span><span
class="n">column1</span><span class="p">,</span><span class="w"> </span><span
class="n">column2</span><span class="p">)</span><span class="w"> </span><span
class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span
class="c1">--------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">corr</span><span class="p">(</span><span
class="n">column1</span><span class="p">,</span><span class="w"> </span><span
class="n">column2</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -1069,15 +1094,15 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">covar_samp</span><span
class="p">(</span><span class="n">expression1</span><span
class="p">,</span><span class="w"> </span><span
class="n">expression2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id37">
-<h4>Arguments<a class="headerlink" href="#id37" title="Link to this
heading">#</a></h4>
+<section id="id39">
+<h4>Arguments<a class="headerlink" href="#id39" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: First expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>expression2</strong>: Second expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id38">
-<h4>Example<a class="headerlink" href="#id38" title="Link to this
heading">#</a></h4>
+<section id="id40">
+<h4>Example<a class="headerlink" href="#id40" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">covar_samp</span><span class="p">(</span><span
class="n">column1</span><span class="p">,</span><span class="w"> </span><span
class="n">column2</span><span class="p">)</span><span class="w"> </span><span
class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class [...]
<span class="o">+</span><span
class="c1">-----------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">covar_samp</span><span class="p">(</span><span
class="n">column1</span><span class="p">,</span><span class="w"> </span><span
class="n">column2</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -1094,15 +1119,15 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">covar_samp</span><span
class="p">(</span><span class="n">expression1</span><span
class="p">,</span><span class="w"> </span><span
class="n">expression2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id39">
-<h4>Arguments<a class="headerlink" href="#id39" title="Link to this
heading">#</a></h4>
+<section id="id41">
+<h4>Arguments<a class="headerlink" href="#id41" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: First expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>expression2</strong>: Second expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id40">
-<h4>Example<a class="headerlink" href="#id40" title="Link to this
heading">#</a></h4>
+<section id="id42">
+<h4>Example<a class="headerlink" href="#id42" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">covar_samp</span><span class="p">(</span><span
class="n">column1</span><span class="p">,</span><span class="w"> </span><span
class="n">column2</span><span class="p">)</span><span class="w"> </span><span
class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class [...]
<span class="o">+</span><span
class="c1">-----------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">covar_samp</span><span class="p">(</span><span
class="n">column1</span><span class="p">,</span><span class="w"> </span><span
class="n">column2</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -1112,8 +1137,8 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
</pre></div>
</div>
</section>
-<section id="id41">
-<h4>Aliases<a class="headerlink" href="#id41" title="Link to this
heading">#</a></h4>
+<section id="id43">
+<h4>Aliases<a class="headerlink" href="#id43" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p>covar</p></li>
</ul>
@@ -1125,15 +1150,15 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<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="w"> </span><span class="k">ORDER</span><span class="w"> </span><span
class="k">BY</span><span class="w"> </span><span
class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id42">
-<h4>Arguments<a class="headerlink" href="#id42" title="Link to this
heading">#</a></h4>
+<section id="id44">
+<h4>Arguments<a class="headerlink" href="#id44" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The column or expression to retrieve the
nth value from.</p></li>
<li><p><strong>n</strong>: The position (nth) of the value to retrieve, based
on the ordering.</p></li>
</ul>
</section>
-<section id="id43">
-<h4>Example<a class="headerlink" href="#id43" title="Link to this
heading">#</a></h4>
+<section id="id45">
+<h4>Example<a class="headerlink" href="#id45" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">dept_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="n">NTH_VALUE</span><span class="p">(</span><span
class="n">salary</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</ [...]
<span class="w"> </span><span class="k">FROM</span><span class="w">
</span><span class="n">employee</span><span class="p">;</span>
<span class="o">+</span><span
class="c1">---------+--------+-------------------------+</span>
@@ -1155,15 +1180,15 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_avgx</span><span
class="p">(</span><span class="n">expression_y</span><span
class="p">,</span><span class="w"> </span><span
class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id44">
-<h4>Arguments<a class="headerlink" href="#id44" title="Link to this
heading">#</a></h4>
+<section id="id46">
+<h4>Arguments<a class="headerlink" href="#id46" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
</ul>
</section>
-<section id="id45">
-<h4>Example<a class="headerlink" href="#id45" title="Link to this
heading">#</a></h4>
+<section id="id47">
+<h4>Example<a class="headerlink" href="#id47" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">create</span><span
class="w"> </span><span class="k">table</span><span class="w"> </span><span
class="n">daily_sales</span><span class="p">(</span><span
class="k">day</span><span class="w"> </span><span class="nb">int</span><span
class="p">,</span><span class="w"> </span><span
class="n">total_sales</span><span class="w"> </span><span
class="nb">int</span><span class="p">)</span><span class="w" [...]
<span class="k">select</span><span class="w"> </span><span
class="o">*</span><span class="w"> </span><span class="k">from</span><span
class="w"> </span><span class="n">daily_sales</span><span class="p">;</span>
<span class="o">+</span><span class="c1">-----+-------------+</span>
@@ -1192,15 +1217,15 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_avgy</span><span
class="p">(</span><span class="n">expression_y</span><span
class="p">,</span><span class="w"> </span><span
class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id46">
-<h4>Arguments<a class="headerlink" href="#id46" title="Link to this
heading">#</a></h4>
+<section id="id48">
+<h4>Arguments<a class="headerlink" href="#id48" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
</ul>
</section>
-<section id="id47">
-<h4>Example<a class="headerlink" href="#id47" title="Link to this
heading">#</a></h4>
+<section id="id49">
+<h4>Example<a class="headerlink" href="#id49" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">create</span><span
class="w"> </span><span class="k">table</span><span class="w"> </span><span
class="n">daily_temperature</span><span class="p">(</span><span
class="k">day</span><span class="w"> </span><span class="nb">int</span><span
class="p">,</span><span class="w"> </span><span
class="n">temperature</span><span class="w"> </span><span
class="nb">int</span><span class="p">)</span><span cla [...]
<span class="k">select</span><span class="w"> </span><span
class="o">*</span><span class="w"> </span><span class="k">from</span><span
class="w"> </span><span class="n">daily_temperature</span><span
class="p">;</span>
<span class="o">+</span><span class="c1">-----+-------------+</span>
@@ -1230,15 +1255,15 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_count</span><span
class="p">(</span><span class="n">expression_y</span><span
class="p">,</span><span class="w"> </span><span
class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id48">
-<h4>Arguments<a class="headerlink" href="#id48" title="Link to this
heading">#</a></h4>
+<section id="id50">
+<h4>Arguments<a class="headerlink" href="#id50" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
</ul>
</section>
-<section id="id49">
-<h4>Example<a class="headerlink" href="#id49" title="Link to this
heading">#</a></h4>
+<section id="id51">
+<h4>Example<a class="headerlink" href="#id51" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">create</span><span
class="w"> </span><span class="k">table</span><span class="w"> </span><span
class="n">daily_metrics</span><span class="p">(</span><span
class="k">day</span><span class="w"> </span><span class="nb">int</span><span
class="p">,</span><span class="w"> </span><span
class="n">user_signups</span><span class="w"> </span><span
class="nb">int</span><span class="p">)</span><span class= [...]
<span class="k">select</span><span class="w"> </span><span
class="o">*</span><span class="w"> </span><span class="k">from</span><span
class="w"> </span><span class="n">daily_metrics</span><span class="p">;</span>
<span class="o">+</span><span class="c1">-----+---------------+</span>
@@ -1267,15 +1292,15 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_intercept</span><span
class="p">(</span><span class="n">expression_y</span><span
class="p">,</span><span class="w"> </span><span
class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id50">
-<h4>Arguments<a class="headerlink" href="#id50" title="Link to this
heading">#</a></h4>
+<section id="id52">
+<h4>Arguments<a class="headerlink" href="#id52" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
</ul>
</section>
-<section id="id51">
-<h4>Example<a class="headerlink" href="#id51" title="Link to this
heading">#</a></h4>
+<section id="id53">
+<h4>Example<a class="headerlink" href="#id53" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">create</span><span
class="w"> </span><span class="k">table</span><span class="w"> </span><span
class="n">weekly_performance</span><span class="p">(</span><span
class="n">week</span><span class="w"> </span><span class="nb">int</span><span
class="p">,</span><span class="w"> </span><span
class="n">productivity_score</span><span class="w"> </span><span
class="nb">int</span><span class="p">)</span> [...]
<span class="k">select</span><span class="w"> </span><span
class="o">*</span><span class="w"> </span><span class="k">from</span><span
class="w"> </span><span class="n">weekly_performance</span><span
class="p">;</span>
<span class="o">+</span><span class="c1">------+---------------------+</span>
@@ -1305,15 +1330,15 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_r2</span><span
class="p">(</span><span class="n">expression_y</span><span
class="p">,</span><span class="w"> </span><span
class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id52">
-<h4>Arguments<a class="headerlink" href="#id52" title="Link to this
heading">#</a></h4>
+<section id="id54">
+<h4>Arguments<a class="headerlink" href="#id54" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
</ul>
</section>
-<section id="id53">
-<h4>Example<a class="headerlink" href="#id53" title="Link to this
heading">#</a></h4>
+<section id="id55">
+<h4>Example<a class="headerlink" href="#id55" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">create</span><span
class="w"> </span><span class="k">table</span><span class="w"> </span><span
class="n">weekly_performance</span><span class="p">(</span><span
class="k">day</span><span class="w"> </span><span class="nb">int</span><span
class="w"> </span><span class="p">,</span><span
class="n">user_signups</span><span class="w"> </span><span
class="nb">int</span><span class="p">)</span><span c [...]
<span class="k">select</span><span class="w"> </span><span
class="o">*</span><span class="w"> </span><span class="k">from</span><span
class="w"> </span><span class="n">weekly_performance</span><span
class="p">;</span>
<span class="o">+</span><span class="c1">-----+--------------+</span>
@@ -1342,15 +1367,15 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_slope</span><span
class="p">(</span><span class="n">expression_y</span><span
class="p">,</span><span class="w"> </span><span
class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id54">
-<h4>Arguments<a class="headerlink" href="#id54" title="Link to this
heading">#</a></h4>
+<section id="id56">
+<h4>Arguments<a class="headerlink" href="#id56" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
</ul>
</section>
-<section id="id55">
-<h4>Example<a class="headerlink" href="#id55" title="Link to this
heading">#</a></h4>
+<section id="id57">
+<h4>Example<a class="headerlink" href="#id57" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">create</span><span
class="w"> </span><span class="k">table</span><span class="w"> </span><span
class="n">weekly_performance</span><span class="p">(</span><span
class="k">day</span><span class="w"> </span><span class="nb">int</span><span
class="p">,</span><span class="w"> </span><span
class="n">user_signups</span><span class="w"> </span><span
class="nb">int</span><span class="p">)</span><span c [...]
<span class="k">select</span><span class="w"> </span><span
class="o">*</span><span class="w"> </span><span class="k">from</span><span
class="w"> </span><span class="n">weekly_performance</span><span
class="p">;</span>
<span class="o">+</span><span class="c1">-----+--------------+</span>
@@ -1379,15 +1404,15 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_sxx</span><span
class="p">(</span><span class="n">expression_y</span><span
class="p">,</span><span class="w"> </span><span
class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id56">
-<h4>Arguments<a class="headerlink" href="#id56" title="Link to this
heading">#</a></h4>
+<section id="id58">
+<h4>Arguments<a class="headerlink" href="#id58" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
</ul>
</section>
-<section id="id57">
-<h4>Example<a class="headerlink" href="#id57" title="Link to this
heading">#</a></h4>
+<section id="id59">
+<h4>Example<a class="headerlink" href="#id59" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">create</span><span
class="w"> </span><span class="k">table</span><span class="w"> </span><span
class="n">study_hours</span><span class="p">(</span><span
class="n">student_id</span><span class="w"> </span><span
class="nb">int</span><span class="p">,</span><span class="w"> </span><span
class="n">hours</span><span class="w"> </span><span class="nb">int</span><span
class="p">,</span><span class="w [...]
<span class="k">select</span><span class="w"> </span><span
class="o">*</span><span class="w"> </span><span class="k">from</span><span
class="w"> </span><span class="n">study_hours</span><span class="p">;</span>
<span class="o">+</span><span
class="c1">------------+-------+------------+</span>
@@ -1416,15 +1441,15 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_sxy</span><span
class="p">(</span><span class="n">expression_y</span><span
class="p">,</span><span class="w"> </span><span
class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id58">
-<h4>Arguments<a class="headerlink" href="#id58" title="Link to this
heading">#</a></h4>
+<section id="id60">
+<h4>Arguments<a class="headerlink" href="#id60" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
</ul>
</section>
-<section id="id59">
-<h4>Example<a class="headerlink" href="#id59" title="Link to this
heading">#</a></h4>
+<section id="id61">
+<h4>Example<a class="headerlink" href="#id61" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">create</span><span
class="w"> </span><span class="k">table</span><span class="w"> </span><span
class="n">employee_productivity</span><span class="p">(</span><span
class="n">week</span><span class="w"> </span><span class="nb">int</span><span
class="p">,</span><span class="w"> </span><span
class="n">productivity_score</span><span class="w"> </span><span
class="nb">int</span><span class="p">)</sp [...]
<span class="k">select</span><span class="w"> </span><span
class="o">*</span><span class="w"> </span><span class="k">from</span><span
class="w"> </span><span class="n">employee_productivity</span><span
class="p">;</span>
<span class="o">+</span><span class="c1">------+--------------------+</span>
@@ -1451,15 +1476,15 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_syy</span><span
class="p">(</span><span class="n">expression_y</span><span
class="p">,</span><span class="w"> </span><span
class="n">expression_x</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id60">
-<h4>Arguments<a class="headerlink" href="#id60" title="Link to this
heading">#</a></h4>
+<section id="id62">
+<h4>Arguments<a class="headerlink" href="#id62" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
</ul>
</section>
-<section id="id61">
-<h4>Example<a class="headerlink" href="#id61" title="Link to this
heading">#</a></h4>
+<section id="id63">
+<h4>Example<a class="headerlink" href="#id63" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">create</span><span
class="w"> </span><span class="k">table</span><span class="w"> </span><span
class="n">employee_productivity</span><span class="p">(</span><span
class="n">week</span><span class="w"> </span><span class="nb">int</span><span
class="p">,</span><span class="w"> </span><span
class="n">productivity_score</span><span class="w"> </span><span
class="nb">int</span><span class="p">)</sp [...]
<span class="k">select</span><span class="w"> </span><span
class="o">*</span><span class="w"> </span><span class="k">from</span><span
class="w"> </span><span class="n">employee_productivity</span><span
class="p">;</span>
<span class="o">+</span><span class="c1">------+--------------------+</span>
@@ -1486,14 +1511,14 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">stddev</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id62">
-<h4>Arguments<a class="headerlink" href="#id62" title="Link to this
heading">#</a></h4>
+<section id="id64">
+<h4>Arguments<a class="headerlink" href="#id64" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id63">
-<h4>Example<a class="headerlink" href="#id63" title="Link to this
heading">#</a></h4>
+<section id="id65">
+<h4>Example<a class="headerlink" href="#id65" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">stddev</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">stddev</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -1503,8 +1528,8 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
</pre></div>
</div>
</section>
-<section id="id64">
-<h4>Aliases<a class="headerlink" href="#id64" title="Link to this
heading">#</a></h4>
+<section id="id66">
+<h4>Aliases<a class="headerlink" href="#id66" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p>stddev_samp</p></li>
</ul>
@@ -1516,14 +1541,14 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">stddev_pop</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id65">
-<h4>Arguments<a class="headerlink" href="#id65" title="Link to this
heading">#</a></h4>
+<section id="id67">
+<h4>Arguments<a class="headerlink" href="#id67" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id66">
-<h4>Example<a class="headerlink" href="#id66" title="Link to this
heading">#</a></h4>
+<section id="id68">
+<h4>Example<a class="headerlink" href="#id68" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">stddev_pop</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span class="c1">--------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">stddev_pop</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -1553,14 +1578,14 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">approx_distinct</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id67">
-<h4>Arguments<a class="headerlink" href="#id67" title="Link to this
heading">#</a></h4>
+<section id="id69">
+<h4>Arguments<a class="headerlink" href="#id69" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id68">
-<h4>Example<a class="headerlink" href="#id68" title="Link to this
heading">#</a></h4>
+<section id="id70">
+<h4>Example<a class="headerlink" href="#id70" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">approx_distinct</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span
class="c1">-----------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">approx_distinct</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -1577,14 +1602,14 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">approx_median</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id69">
-<h4>Arguments<a class="headerlink" href="#id69" title="Link to this
heading">#</a></h4>
+<section id="id71">
+<h4>Arguments<a class="headerlink" href="#id71" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id70">
-<h4>Example<a class="headerlink" href="#id70" title="Link to this
heading">#</a></h4>
+<section id="id72">
+<h4>Example<a class="headerlink" href="#id72" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">approx_median</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span
class="c1">-----------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">approx_median</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -1601,16 +1626,16 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span
class="n">approx_percentile_cont</span><span class="p">(</span><span
class="n">percentile</span><span class="w"> </span><span
class="p">[,</span><span class="w"> </span><span
class="n">centroids</span><span class="p">])</span><span class="w">
</span><span class="n">WITHIN</span><span class="w"> </span><span
class="k">GROUP</span><span class="w"> </span><span class="p">(</span><span
class="k">ORDER</span [...]
</pre></div>
</div>
-<section id="id71">
-<h4>Arguments<a class="headerlink" href="#id71" title="Link to this
heading">#</a></h4>
+<section id="id73">
+<h4>Arguments<a class="headerlink" href="#id73" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>percentile</strong>: Percentile to compute. Must be a float
value between 0 and 1 (inclusive).</p></li>
<li><p><strong>centroids</strong>: Number of centroids to use in the t-digest
algorithm. <em>Default is 100</em>. A higher number results in more accurate
approximation but requires more memory.</p></li>
</ul>
</section>
-<section id="id72">
-<h4>Example<a class="headerlink" href="#id72" title="Link to this
heading">#</a></h4>
+<section id="id74">
+<h4>Example<a class="headerlink" href="#id74" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">approx_percentile_cont</span><span class="p">(</span><span
class="mi">0</span><span class="p">.</span><span class="mi">75</span><span
class="p">)</span><span class="w"> </span><span class="n">WITHIN</span><span
class="w"> </span><span class="k">GROUP</span><span class="w"> </span><span
class [...]
<span class="o">+</span><span
class="c1">------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">approx_percentile_cont</span><span class="p">(</span><span
class="mi">0</span><span class="p">.</span><span class="mi">75</span><span
class="p">)</span><span class="w"> </span><span class="n">WITHIN</span><span
class="w"> </span><span class="k">GROUP</span><span class="w"> </span><span
class="p">(</span><span class="k">ORDER</span><span class="w"> </span><span
class="k">BY</span><span class="w"> </span><span class="k">column [...]
@@ -1649,8 +1674,8 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span
class="n">approx_percentile_cont_with_weight</span><span
class="p">(</span><span class="n">weight</span><span class="p">,</span><span
class="w"> </span><span class="n">percentile</span><span class="w">
</span><span class="p">[,</span><span class="w"> </span><span
class="n">centroids</span><span class="p">])</span><span class="w">
</span><span class="n">WITHIN</span><span class="w"> </span><span class="k [...]
</pre></div>
</div>
-<section id="id73">
-<h4>Arguments<a class="headerlink" href="#id73" title="Link to this
heading">#</a></h4>
+<section id="id75">
+<h4>Arguments<a class="headerlink" href="#id75" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>weight</strong>: Expression to use as weight. Can be a
constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1658,8 +1683,8 @@ This aggregation function can only mix DISTINCT and ORDER
BY if the ordering exp
<li><p><strong>centroids</strong>: Number of centroids to use in the t-digest
algorithm. <em>Default is 100</em>. A higher number results in more accurate
approximation but requires more memory.</p></li>
</ul>
</section>
-<section id="id74">
-<h4>Example<a class="headerlink" href="#id74" title="Link to this
heading">#</a></h4>
+<section id="id76">
+<h4>Example<a class="headerlink" href="#id76" title="Link to this
heading">#</a></h4>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">approx_percentile_cont_with_weight</span><span
class="p">(</span><span class="n">weight_column</span><span
class="p">,</span><span class="w"> </span><span class="mi">0</span><span
class="p">.</span><span class="mi">90</span><span class="p">)</span><span
class="w"> </span><span class="n">WITH [...]
<span class="o">+</span><span
class="c1">---------------------------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">approx_percentile_cont_with_weight</span><span
class="p">(</span><span class="n">weight_column</span><span
class="p">,</span><span class="w"> </span><span class="mi">0</span><span
class="p">.</span><span class="mi">90</span><span class="p">)</span><span
class="w"> </span><span class="n">WITHIN</span><span class="w"> </span><span
class="k">GROUP</span><span class="w"> </span><span class="p">(</span><span
class="k">ORDER</span [...]
@@ -1738,102 +1763,107 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
<li class="toc-h2 nav-item toc-entry"><a class="reference internal nav-link"
href="#filter-clause">Filter clause</a></li>
<li class="toc-h2 nav-item toc-entry"><a class="reference internal nav-link"
href="#within-group-ordered-set-aggregates">WITHIN GROUP / Ordered-set
aggregates</a></li>
<li class="toc-h2 nav-item toc-entry"><a class="reference internal nav-link"
href="#general-functions">General Functions</a><ul class="nav section-nav
flex-column">
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#array-agg"><code class="docutils literal notranslate"><span
class="pre">array_agg</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#any-value"><code class="docutils literal notranslate"><span
class="pre">any_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="#arguments">Arguments</a></li>
<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="#avg"><code class="docutils literal notranslate"><span
class="pre">avg</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#array-agg"><code class="docutils literal notranslate"><span
class="pre">array_agg</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">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id2">Example</a></li>
+</ul>
+</li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#avg"><code class="docutils literal notranslate"><span
class="pre">avg</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">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id4">Example</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#aliases">Aliases</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#bit-and"><code class="docutils literal notranslate"><span
class="pre">bit_and</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">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id5">Arguments</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#bit-or"><code class="docutils literal notranslate"><span
class="pre">bit_or</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">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id6">Arguments</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#bit-xor"><code class="docutils literal notranslate"><span
class="pre">bit_xor</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">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id7">Arguments</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#bool-and"><code class="docutils literal notranslate"><span
class="pre">bool_and</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="#id6">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id7">Example</a></li>
-</ul>
-</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#bool-or"><code class="docutils literal notranslate"><span
class="pre">bool_or</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</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id9">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#count"><code class="docutils literal notranslate"><span
class="pre">count</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#bool-or"><code class="docutils literal notranslate"><span
class="pre">bool_or</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</a></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="#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-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#count"><code class="docutils literal notranslate"><span
class="pre">count</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="#grouping"><code class="docutils literal notranslate"><span
class="pre">grouping</span></code></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></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</a></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-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#grouping"><code class="docutils literal notranslate"><span
class="pre">grouping</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="#id16">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id17">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#max"><code class="docutils literal notranslate"><span
class="pre">max</span></code></a><ul class="nav section-nav flex-column">
+<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="#id18">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id19">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#mean"><code class="docutils literal notranslate"><span
class="pre">mean</span></code></a></li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#median"><code class="docutils literal notranslate"><span
class="pre">median</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#max"><code class="docutils literal notranslate"><span
class="pre">max</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="#id20">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id21">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#min"><code class="docutils literal notranslate"><span
class="pre">min</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#mean"><code class="docutils literal notranslate"><span
class="pre">mean</span></code></a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#median"><code class="docutils literal notranslate"><span
class="pre">median</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="#id22">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id23">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#percentile-cont"><code class="docutils literal notranslate"><span
class="pre">percentile_cont</span></code></a><ul class="nav section-nav
flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#min"><code class="docutils literal notranslate"><span
class="pre">min</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="#id24">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id25">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id26">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#quantile-cont"><code class="docutils literal notranslate"><span
class="pre">quantile_cont</span></code></a></li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#string-agg"><code class="docutils literal notranslate"><span
class="pre">string_agg</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="#id27">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id28">Example</a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#percentile-cont"><code class="docutils literal notranslate"><span
class="pre">percentile_cont</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="#id26">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id27">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id28">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#sum"><code class="docutils literal notranslate"><span
class="pre">sum</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#quantile-cont"><code class="docutils literal notranslate"><span
class="pre">quantile_cont</span></code></a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#string-agg"><code class="docutils literal notranslate"><span
class="pre">string_agg</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="#id29">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id30">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#var"><code class="docutils literal notranslate"><span
class="pre">var</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#sum"><code class="docutils literal notranslate"><span
class="pre">sum</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="#id31">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id32">Aliases</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id32">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#var-pop"><code class="docutils literal notranslate"><span
class="pre">var_pop</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#var"><code class="docutils literal notranslate"><span
class="pre">var</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="#id33">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id34">Aliases</a></li>
</ul>
</li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#var-pop"><code class="docutils literal notranslate"><span
class="pre">var_pop</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="#id35">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id36">Aliases</a></li>
+</ul>
+</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#var-population"><code class="docutils literal notranslate"><span
class="pre">var_population</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#var-samp"><code class="docutils literal notranslate"><span
class="pre">var_samp</span></code></a></li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#var-sample"><code class="docutils literal notranslate"><span
class="pre">var_sample</span></code></a></li>
@@ -1841,81 +1871,81 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
</li>
<li class="toc-h2 nav-item toc-entry"><a class="reference internal nav-link"
href="#statistical-functions">Statistical Functions</a><ul class="nav
section-nav flex-column">
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#corr"><code class="docutils literal notranslate"><span
class="pre">corr</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="#id35">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id36">Example</a></li>
-</ul>
-</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#covar"><code class="docutils literal notranslate"><span
class="pre">covar</span></code></a></li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#covar-pop"><code class="docutils literal notranslate"><span
class="pre">covar_pop</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="#id37">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id38">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#covar-samp"><code class="docutils literal notranslate"><span
class="pre">covar_samp</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#covar"><code class="docutils literal notranslate"><span
class="pre">covar</span></code></a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#covar-pop"><code class="docutils literal notranslate"><span
class="pre">covar_pop</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="#id39">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id40">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id41">Aliases</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="#id42">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id43">Example</a></li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#covar-samp"><code class="docutils literal notranslate"><span
class="pre">covar_samp</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="#id41">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id42">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id43">Aliases</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-avgx"><code class="docutils literal notranslate"><span
class="pre">regr_avgx</span></code></a><ul class="nav section-nav flex-column">
+<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="#id44">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id45">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-avgy"><code class="docutils literal notranslate"><span
class="pre">regr_avgy</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-avgx"><code class="docutils literal notranslate"><span
class="pre">regr_avgx</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="#id46">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id47">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-count"><code class="docutils literal notranslate"><span
class="pre">regr_count</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-avgy"><code class="docutils literal notranslate"><span
class="pre">regr_avgy</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="#id48">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id49">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-intercept"><code class="docutils literal notranslate"><span
class="pre">regr_intercept</span></code></a><ul class="nav section-nav
flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-count"><code class="docutils literal notranslate"><span
class="pre">regr_count</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="#id50">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id51">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-r2"><code class="docutils literal notranslate"><span
class="pre">regr_r2</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-intercept"><code class="docutils literal notranslate"><span
class="pre">regr_intercept</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="#id52">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id53">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-slope"><code class="docutils literal notranslate"><span
class="pre">regr_slope</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-r2"><code class="docutils literal notranslate"><span
class="pre">regr_r2</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="#id54">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id55">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-sxx"><code class="docutils literal notranslate"><span
class="pre">regr_sxx</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-slope"><code class="docutils literal notranslate"><span
class="pre">regr_slope</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="#id56">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id57">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-sxy"><code class="docutils literal notranslate"><span
class="pre">regr_sxy</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-sxx"><code class="docutils literal notranslate"><span
class="pre">regr_sxx</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="#id58">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id59">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-syy"><code class="docutils literal notranslate"><span
class="pre">regr_syy</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-sxy"><code class="docutils literal notranslate"><span
class="pre">regr_sxy</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="#id60">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id61">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#stddev"><code class="docutils literal notranslate"><span
class="pre">stddev</span></code></a><ul class="nav section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#regr-syy"><code class="docutils literal notranslate"><span
class="pre">regr_syy</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="#id62">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id63">Example</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id64">Aliases</a></li>
+</ul>
+</li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#stddev"><code class="docutils literal notranslate"><span
class="pre">stddev</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="#id64">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id65">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id66">Aliases</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#stddev-pop"><code class="docutils literal notranslate"><span
class="pre">stddev_pop</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="#id65">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id66">Example</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id67">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id68">Example</a></li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#stddev-samp"><code class="docutils literal notranslate"><span
class="pre">stddev_samp</span></code></a></li>
@@ -1923,25 +1953,25 @@ This aggregation function can only mix DISTINCT and
ORDER BY if the ordering exp
</li>
<li class="toc-h2 nav-item toc-entry"><a class="reference internal nav-link"
href="#approximate-functions">Approximate Functions</a><ul class="nav
section-nav flex-column">
<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#approx-distinct"><code class="docutils literal notranslate"><span
class="pre">approx_distinct</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="#id67">Arguments</a></li>
-<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id68">Example</a></li>
-</ul>
-</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#approx-median"><code class="docutils literal notranslate"><span
class="pre">approx_median</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="#id69">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id70">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#approx-percentile-cont"><code class="docutils literal notranslate"><span
class="pre">approx_percentile_cont</span></code></a><ul class="nav section-nav
flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#approx-median"><code class="docutils literal notranslate"><span
class="pre">approx_median</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="#id71">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id72">Example</a></li>
</ul>
</li>
-<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#approx-percentile-cont-with-weight"><code class="docutils literal
notranslate"><span
class="pre">approx_percentile_cont_with_weight</span></code></a><ul class="nav
section-nav flex-column">
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#approx-percentile-cont"><code class="docutils literal notranslate"><span
class="pre">approx_percentile_cont</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="#id73">Arguments</a></li>
<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id74">Example</a></li>
</ul>
</li>
+<li class="toc-h3 nav-item toc-entry"><a class="reference internal nav-link"
href="#approx-percentile-cont-with-weight"><code class="docutils literal
notranslate"><span
class="pre">approx_percentile_cont_with_weight</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="#id75">Arguments</a></li>
+<li class="toc-h4 nav-item toc-entry"><a class="reference internal nav-link"
href="#id76">Example</a></li>
+</ul>
+</li>
</ul>
</li>
</ul>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
