From clause
A FROM clause is the SQL query component that specifies the tables or other data sources providing input rows.
DuckDB in Action
The FROM clause specifies the relations that provide the input data for a SQL query.
- How it is used
- Defines query input sources before filtering, grouping, joining, or projecting results.
- How deep it goes
- Explains tables, inline values, subqueries, CTEs, joins, and recursive sources, but defers full SELECT reference details.
- Examples
- Demonstrates prices, VALUES relations, grouped readings, file joins, subqueries, CTEs, and recursive parent-child paths.
- What you can do after
- Apply it to read tables, filter inputs, combine relations, and build larger analytical queries.
Learn SQL in a Month of Lunches
A FROM clause is the SQL clause that specifies the table or other data source from which data is retrieved or related data is selected.
- How it is used
- Identifies the data set that supplies rows for retrieval queries and multi-table joins.
- How deep it goes
- Defines FROM, demonstrates a one-table query, and notes clause order, joins, variables, and DELETE portability.
- Examples
- Uses a vegetables table, customer-order date filtering, title-sales thresholds, and deletion by TitleID.
- What you can do after
- Apply it to name a query's source table, join related tables, and retain portable DELETE syntax.
Read how Learn SQL in a Month of Lunches explains from clause →
Grokking Relational Database Design
A FROM clause specifies the table or tables that provide the source rows for an SQL query.
- How it is used
- Uses FROM to identify the source rows for queries that retrieve and filter data.
- How deep it goes
- Defines FROM and demonstrates it in a SELECT-WHERE query, without exploring query execution internals.
- Examples
- Demonstrates FROM product in a query that returns names of products priced above 20.
- What you can do after
- Apply it via SQL by selecting source rows from a named table and combining FROM with SELECT and WHERE.
Read how Grokking Relational Database Design explains from clause →
Also covered in
What to know first
- SQLSQL is a standardized declarative language for defining, querying, and manipulating data in relational database systems.
- database tableA database table is a relational data structure that organizes records into rows whose values correspond to defined columns.
- where clauseA WHERE clause is a query-language clause that restricts returned or affected rows or records according to a specified condition.
Related concepts
- SQLpart of · SQL is a standardized declarative language for defining, querying, and manipulating data in relational database systems.
- datasetuses · A dataset is an organized collection of related data items, records, observations, or examples treated as a unit for storage, processing, or analysis.
- joinhas part · A join is an operation that combines records or data elements from multiple inputs according to matching or related values or conditions.
- join conditionhas part · A join condition is a Boolean predicate specifying how rows from joined tables correspond to one another.
- keywordkind of · A language-defined word or token with a predefined syntactic or semantic role, which may be restricted from use as an ordinary identifier.
- subqueryhas part · A subquery is a query embedded within another query or statement whose result contributes to evaluating the containing operation.
Questions about from clause
What is from clause?
A FROM clause is the SQL query component that specifies the tables or other data sources providing input rows.
Which Manning books explain from clause?
DuckDB in Action, Learn SQL in a Month of Lunches and Grokking Relational Database Design.
What should I know before learning from clause?
Manning books that teach from clause usually introduce SQL, database table and where clause first.
What is from clause a kind of?
From clause is a kind of keyword. A language-defined word or token with a predefined syntactic or semantic role, which may be restricted from use as an ordinary identifier.
What is from clause part of?
From clause is part of SQL. SQL is a standardized declarative language for defining, querying, and manipulating data in relational database systems.
What are the parts of from clause?
From clause includes join, join condition and subquery.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.


