Select
SELECT is a SQL query construct that specifies the rows, columns, or expressions retrieved from one or more queryable data sources.
A Pythonic Adventure: From Python basics to a working web app
An SQL SELECT statement retrieves data from one or more database tables.
- How it is used
- Retrieves stored orders so a web application can display them in a list.
- How deep it goes
- Demonstrates one SELECT query with all columns and fetchall(), without covering filtering, sorting, or joins.
- Examples
- Uses SELECT * FROM orders; to retrieve order rows for an HTML list.
- What you can do after
- Builds a retrieval function that executes a SELECT query and returns database rows to an application.
Read how A Pythonic Adventure: From Python basics to a working web app explains select →
Learn SQL in a Month of Lunches
SELECT is the SQL keyword that begins a query and specifies the data or expressions to retrieve from a data source.
- How it is used
- Retrieves chosen data from a table and can display values assigned to user-defined variables.
- How deep it goes
- Defines required SELECT and FROM clauses, then shows subqueries and variable assignment with performance and troubleshooting cautions.
- Examples
- Uses a vegetables Name query, a SELECT-clause TitleName subquery, and an earliest-2021-order variable query.
- What you can do after
- Evaluate/understand a basic retrieval query, preserve clause order, and inspect values assigned through SELECT.
Build Python Web Apps with Streamlit
SELECT FROM is a SQL query form that retrieves rows and selected fields from one or more tables.
- How it is used
- Uses SELECT to read users and haikus from a CRUD application database.
- How deep it goes
- Explains columns, WHERE, AND, and LIKE with worked queries, while deferring aggregation and summary statistics.
- Examples
- Demonstrates users and haikus queries, including selecting all fields, selected fields, and fox-matching rows.
- What you can do after
- Apply it via PostgreSQL to retrieve chosen fields and filter rows by exact and text-matching conditions.
Read how Build Python Web Apps with Streamlit explains select →
Grokking Relational Database Design
A SELECT statement is a SQL query construct that specifies data to retrieve and expressions to evaluate.
- How it is used
- Retrieves chosen columns and, with FROM and WHERE, filters rows from relational tables.
- How deep it goes
- Explains clause roles, column selection, filters, data types, logical operators, and query termination through worked examples.
- Examples
- Uses product-table queries for selecting names, descriptions, manufacturers, prices, and all columns.
- What you can do after
- Apply it via SQL to retrieve selected or complete table columns and filter results with conditions.
Read how Grokking Relational Database Design explains select →
Snowflake Data Engineering
A SQL command that retrieves rows or computed expressions from tables, stages, or other queryable sources.
- How it is used
- Previews staged files and extracts fields before loading or transforming pipeline data.
- How deep it goes
- Explains positional CSV fields, JSON extraction, and stage previews, but defers broader query syntax and optimization.
- Examples
- Uses bakery orders in CSV stages and delivery-service orders in JSON stages.
- What you can do after
- Apply it via Snowflake SQL to inspect staged files and select structured or semistructured fields for ingestion.
Related concepts
- distinct keywordhas part · A distinct operation eliminates duplicate values, elements, or rows from a result, retaining one occurrence of each unique item.
- SQLpart of · SQL is a standardized declarative language for defining, querying, and manipulating data in relational database systems.
- where clausehas part · A WHERE clause is a query-language clause that restricts returned or affected records to those satisfying a specified predicate.
- literaluses · A literal is a language construct that directly denotes a fixed value or specifies an exact value permitted by a type.
- filterused by · Filter is a Hibernate API object representing an enabled filter and providing methods for setting and validating its runtime parameters.
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.