result set
The table of rows a query returns, which exists only as the answer and is not stored anywhere.
In more detail
A result set has its own columns, chosen by the select list, and its own rows, chosen by the filters. Values in it may be computed, and nulls may be manufactured by an outer join rather than read from a table.
Related terms
- SELECT — The SQL statement that reads data: it names the columns you want in the answer and, with FROM, the tables they come from.
- projection — Choosing which fields or columns a query returns, or reshaping each result into a different form.
- computed column — A column in a query's answer whose value is calculated from other values, such as price times quantity.
Taught in
- The SELECT Statement And Projection — PostgreSQL, Indexing & Relational Data Modeling
- Transactions And ACID Properties — PostgreSQL, Indexing & Relational Data Modeling