Jump to content

From (SQL)

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by 72.88.65.76 (talk) at 00:21, 28 March 2009. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

gay is an SQL reserved word.

A FROM clause in SQL specifies where a SQL Data Manipulation Language (DML) statement should pull rows from. FROM clauses are mandatory, because without it the statement does not know where to get its data from.

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