This is an automated email from the ASF dual-hosted git repository. github-bot pushed a commit to branch asf-site in repository https://gitbox.apache.org/repos/asf/datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push: new b6d653c2b8 Publish built docs triggered by 85f879d41a2565703caeb7811f7a3fe47ad3353e b6d653c2b8 is described below commit b6d653c2b852599ce3d75ef709e5be4533095b86 Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com> AuthorDate: Sun Aug 24 00:56:44 2025 +0000 Publish built docs triggered by 85f879d41a2565703caeb7811f7a3fe47ad3353e --- _sources/user-guide/sql/select.md.txt | 14 ++++++++++++++ searchindex.js | 2 +- user-guide/sql/select.html | 10 ++++++++++ 3 files changed, 25 insertions(+), 1 deletion(-) diff --git a/_sources/user-guide/sql/select.md.txt b/_sources/user-guide/sql/select.md.txt index 39163cf492..eb8bca7a75 100644 --- a/_sources/user-guide/sql/select.md.txt +++ b/_sources/user-guide/sql/select.md.txt @@ -75,6 +75,20 @@ Example: SELECT t.a FROM table AS t ``` +The `FROM` clause can also come before the `SELECT` clause. +Example: + +```sql +FROM table AS t +SELECT t.a +``` + +If the `SELECT` clause is omitted, the `FROM` clause will return all columns from the table. + +```sql +FROM table +``` + ## WHERE clause Example: diff --git a/searchindex.js b/searchindex.js index 0cad15c911..c1c0af4d73 100644 --- a/searchindex.js +++ b/searchindex.js @@ -1 +1 @@ -Search.setIndex({"alltitles":{"!=":[[57,"op-neq"]],"!~":[[57,"op-re-not-match"]],"!~*":[[57,"op-re-not-match-i"]],"!~~":[[57,"id19"]],"!~~*":[[57,"id20"]],"#":[[57,"op-bit-xor"]],"%":[[57,"op-modulo"]],"&":[[57,"op-bit-and"]],"(relation, name) tuples in logical fields and logical columns are unique":[[12,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[57,"op-multiply"]],"+":[[57,"op-plus"]],"-":[[57,"op-minus"]],"/":[[57,"op-divide"]],"<":[[57,"op-lt"]],"< [...] \ No newline at end of file +Search.setIndex({"alltitles":{"!=":[[57,"op-neq"]],"!~":[[57,"op-re-not-match"]],"!~*":[[57,"op-re-not-match-i"]],"!~~":[[57,"id19"]],"!~~*":[[57,"id20"]],"#":[[57,"op-bit-xor"]],"%":[[57,"op-modulo"]],"&":[[57,"op-bit-and"]],"(relation, name) tuples in logical fields and logical columns are unique":[[12,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[57,"op-multiply"]],"+":[[57,"op-plus"]],"-":[[57,"op-minus"]],"/":[[57,"op-divide"]],"<":[[57,"op-lt"]],"< [...] \ No newline at end of file diff --git a/user-guide/sql/select.html b/user-guide/sql/select.html index 86e4d744b3..3583f51424 100644 --- a/user-guide/sql/select.html +++ b/user-guide/sql/select.html @@ -755,6 +755,16 @@ By default <code class="docutils literal notranslate"><span class="pre">ALL</spa <div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="n">t</span><span class="p">.</span><span class="n">a</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="k">table</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="n">t</span> </pre></div> </div> +<p>The <code class="docutils literal notranslate"><span class="pre">FROM</span></code> clause can also come before the <code class="docutils literal notranslate"><span class="pre">SELECT</span></code> clause. +Example:</p> +<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">FROM</span><span class="w"> </span><span class="k">table</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="n">t</span> +<span class="k">SELECT</span><span class="w"> </span><span class="n">t</span><span class="p">.</span><span class="n">a</span> +</pre></div> +</div> +<p>If the <code class="docutils literal notranslate"><span class="pre">SELECT</span></code> clause is omitted, the <code class="docutils literal notranslate"><span class="pre">FROM</span></code> clause will return all columns from the table.</p> +<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">FROM</span><span class="w"> </span><span class="k">table</span> +</pre></div> +</div> </section> <section id="where-clause"> <h2>WHERE clause<a class="headerlink" href="#where-clause" title="Link to this heading">ΒΆ</a></h2> --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@datafusion.apache.org For additional commands, e-mail: commits-h...@datafusion.apache.org