Jump to content

From (SQL)

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Fleurydj (talk | contribs) at 20:31, 16 November 2007 (Created page with '<code>FROM</code> is an SQL reserved word. The <code>FROM</code> clause is used in conjunction with SQL statements, and takes the following general fo...'). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

FROM is an SQL reserved word.

The FROM clause is used in conjunction with SQL statements, and takes the following general form:

 SQL-DML-Statement
 FROM table_name 
 WHERE predicate

Examples

The following query returns only those rows from table mytable where the value in column mycol is greater than 100.

 SELECT *
 FROM   mytable
 WHERE  mycol > 100