Jump to content

From (SQL)

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by GregorB (talk | contribs) at 10:48, 17 November 2007 (Category:SQL keywords). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

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