From (SQL)

<h2 id="examples">Examples</h2>
<p>The following query returns only those rows from table <i>mytable</i> where the value in column <i>mycol</i> is greater than 100.
</p>
SELECT *
FROM   mytable
WHERE  mycol > 100

<h2 id="requirement">Requirement</h2>
<p>The From clause is technically required in <a href="/facts/Relational_algebra/7tjTFXdf">relational algebra</a> and in most scenarios to be useful.  However many <a href="/facts/Database/VYcpkevb">relational DBMS</a> implementations may not require it for selecting a single value, or single row - known as <a href="/facts/DUAL_table/axv1Q4BF">DUAL table</a> in <a href="/facts/Oracle_database/FHv5g732">Oracle database</a>.<a class="footnote-ref" id="fnref:4" href="#fn:4"><sup>4</sup></a>
</p>
SELECT 3.14 AS Pi

<p>Other systems will require a From statement with a keyword, even to select system data.<a class="footnote-ref" id="fnref:5" href="#fn:5"><sup>5</sup></a>  
</p>
select to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS') as "Current Time"
from dual;

<h2 id="references">References</h2>

<ol>
<li id="fn:1"><p>"From clause in Transact SQL". <a href="https://docs.microsoft.com/de-de/sql/t-sql/queries/from-transact-sql?view=sql-server-2017" target="_blank">https://docs.microsoft.com/de-de/sql/t-sql/queries/from-transact-sql?view=sql-server-2017</a> <a href="#fnref:1" class="footnote-back-ref">↩</a></p></li>
<li id="fn:2"><p>"Reserved Words in SQL". <a href="https://www.drupal.org/docs/develop/coding-standards/list-of-sql-reserved-words" target="_blank">https://www.drupal.org/docs/develop/coding-standards/list-of-sql-reserved-words</a> <a href="#fnref:2" class="footnote-back-ref">↩</a></p></li>
<li id="fn:3"><p>"System Information Schema Views (Transact-SQL)". <a href="https://docs.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/system-information-schema-views-transact-sql?view=sql-server-2017" target="_blank">https://docs.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/system-information-schema-views-transact-sql?view=sql-server-2017</a> <a href="#fnref:3" class="footnote-back-ref">↩</a></p></li>
<li id="fn:4"><p>"Selecting from the DUAL Table". <a href="https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries009.htm" target="_blank">https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries009.htm</a> <a href="#fnref:4" class="footnote-back-ref">↩</a></p></li>
<li id="fn:5"><p>"Oracle Dates and Times". <a href="http://infolab.stanford.edu/~ullman/fcdb/oracle/or-time.html" target="_blank">http://infolab.stanford.edu/~ullman/fcdb/oracle/or-time.html</a> <a href="#fnref:5" class="footnote-back-ref">↩</a></p></li>
</ol>

From (SQL) open-in-new

From (SQL)