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.
Also covered in
- DuckDB in Action
- ScyllaDB in Action
- Kotlin in Action, 2E
- Data Analysis with LLMs
- Logs and Telemetry
- Just Use Postgres!
- Software Engineering for Data ScientistsIn early access (MEAP)
- Building Web APIs with ASP.NET Core
What to know first
- SQLSQL is a standardized declarative language for defining, querying, and manipulating data in relational database systems.
- columnA column is a vertical sequence or region of cells or entries in a table, grid, or matrix; in tabular data, it represents one attribute across records.
- CSVCSV is a text format for tabular data in which records contain fields separated by commas, with conventions for quoting fields that contain special characters.
- clientA client is a person, organization, device, or software component that receives or uses a product, service, resource, or functionality provided by another party or system.
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.
- cursorused by · A database cursor is an API object or handle that provides access to query results and supports traversing or retrieving them, often incrementally.
- data aggregationused by · Data aggregation is the process of combining multiple data values, records, or observations into a consolidated or summarized result.
- stream processingused by · Stream processing is the incremental processing of data items as they become available, without requiring the complete dataset to be present first.
Questions about select
What is select?
SELECT is a SQL query construct that specifies the rows, columns, or expressions retrieved from one or more queryable data sources.
Which Manning books explain select?
A Pythonic Adventure: From Python basics to a working web app, Learn SQL in a Month of Lunches, Build Python Web Apps with Streamlit, Grokking Relational Database Design and Snowflake Data Engineering.
What should I know before learning select?
Manning books that teach select usually introduce SQL, column, CSV and client first.
What is select part of?
Select 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 select?
Select includes distinct keyword.
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.




