Our website is made possible by displaying online advertisements to our visitors.
Please consider supporting us by disabling your ad blocker.

Responsive image


From (SQL)

The SQL From clause is the source of a rowset to be operated upon in a Data Manipulation Language (DML) statement. From clauses are very common, and will provide the rowset to be exposed through a Select statement, the source of values in an Update statement, and the target rows to be deleted in a Delete statement. [1]

FROM is an SQL reserved word in the SQL standard. [2]

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

 SQL-DML-Statement
 FROM table_name 
 WHERE predicate

The From clause can generally be anything that returns a rowset, a table, view, function, or system-provided information like the Information Schema, which is typically running proprietary commands and returning the information in a table form.[3]

  1. ^ "From clause in Transact SQL".
  2. ^ "Reserved Words in SQL".
  3. ^ "System Information Schema Views (Transact-SQL)".

Previous Page Next Page






From (SQL) German From (SQL) Dutch From (SQL) Portuguese From (SQL) Russian From (SQL) SQ From (SQL) Ukrainian

Responsive image

Responsive image