From (SQL)
Appearance
Look up from (sql) in Wiktionary, the free dictionary.
![]() | This article needs attention from an expert on the subject. Please add a reason or a talk parameter to this template to explain the issue with the article. |
FROM
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