Select

As explained in 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 Build Python Web Apps with Streamlit covers it

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 it assumes

Requires populated database tables and familiarity with table and column names.

What you can do after

Apply it via PostgreSQL to retrieve chosen fields and filter rows by exact and text-matching conditions.

How it connects

Connects SELECT with tables, columns, WHERE clauses, AND conditions, and LIKE text matching.

liveBookmanning.com

Read Build Python Web Apps with Streamlit on liveBook Get the book at manning.com

Also explained in

• 

  liveBookmanning.com
  A Pythonic Adventure: From Python basics to a working web appAn SQL SELECT statement retrieves data from one or more database tables.
• 

  liveBookmanning.com
  Learn SQL in a Month of LunchesSELECT is the SQL keyword that begins a query and specifies the data or expressions to retrieve from a data source.
• 

  liveBookmanning.com
  Grokking Relational Database DesignA SELECT statement is a SQL query construct that specifies data to retrieve and expressions to evaluate.
• 

  liveBookmanning.com
  Snowflake Data EngineeringA SQL command that retrieves rows or computed expressions from tables, stages, or other queryable sources.

Compare how 5 books explain select →

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 and structures 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.

This explainer was generated by Manning's knowledge graph from the text of Build Python Web Apps with Streamlit. The section links point to the parts of the book it draws on.