liveBook · Manning

Query result

Also called result set

A query result is the collection of rows and columns produced by evaluating a database query.

How 4 Manning books explain it

Learn SQL in a Month of Lunches

A query result, or result set, is the tabular collection of rows returned by executing a database query.

How it is used
Returns rows that answer SELECT queries and provides the input or output evaluated by set operators.
How deep it goes
Defines SELECT output as rows and details compatibility, naming, and ordering rules for combining results.
Examples
Uses title names and customer and author names, including filtered names and a source-label column.
What you can do after
Evaluate/understand query output, avoid assuming its order, and combine compatible SELECT results with UNION.

Read how Learn SQL in a Month of Lunches explains query result →

Data-Oriented Programming: Reduce software complexity

A JDBC result set is an object that provides access to the tabular rows returned by a JDBC database query.

How it is used
Feeds database query results into generic collection-processing and JSON-serving pipelines.
How deep it goes
Shows metadata-driven iteration and Object-valued extraction, stopping short of detailed JDBC lifecycle or resource-management treatment.
Examples
Uses a book-search query, returned book rows, JSON-shaped maps, and a JDBC conversion utility.
What you can do after
Build it from scratch as a metadata-driven conversion from JDBC rows to maps suitable for downstream serialization.

Read how Data-Oriented Programming: Reduce software complexity explains query result →

Data Analysis with LLMs

A query result is the table of rows and columns produced by executing a database query.

How it is used
Supports answering natural-language data questions by providing the output generated after a formal query runs on structured data.
How deep it goes
Explains result-row retrieval and string formatting, while stopping short of a full SQL introduction.
Examples
Uses filtered game rows, counts of 2017 games, grouped publisher or genre results, and Python row retrieval.
What you can do after
Operate SQLite queries from Python and retrieve their rows as formatted text.

Read how Data Analysis with LLMs explains query result →

Python Concurrency with asyncio

A database result set is the collection of rows produced by executing a database query.

How it is used
Uses query results to read database rows in asynchronous Python applications.
How deep it goes
Explains in-memory fetching, single-row retrieval, and cursor-based streaming, without detailing cursor internals.
Examples
Demonstrates selecting inserted brands and printing their identifiers and names.
What you can do after
Apply result retrieval via asyncpg, selecting between complete fetching, single-row access, and streaming.

Read how Python Concurrency with asyncio explains query result →

Also covered in

What to know first

Related concepts

Questions about query result

What is query result?

A query result is the collection of rows and columns produced by evaluating a database query.

Which Manning books explain query result?

Learn SQL in a Month of Lunches, Data-Oriented Programming: Reduce software complexity, Data Analysis with LLMs and Python Concurrency with asyncio.

What should I know before learning query result?

Manning books that teach query result usually introduce SQL, Python and database table first.

What is query result also called?

Query result is also called result set.

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.