Concept
Result set
In databases, a result set is the set of results returned by a query. In SQL, it is the result of a SELECT query on a table or view and is itself a non-permanent table of rows, and could include metadata about the query such as the column names, and the types and sizes of each column. Depending on the database system, the number of rows in the result set may or may not be known. Usually, this number is not known up front because the result set is built on-the-fly. A cursor can be used by client applications to fetch a few rows of the result set at a time.
- READ ONLY RESULTSET
- UPDATABLE RESULTSET read more There is no guarantee that the rows of a result set returned by a SELECT query are in any particular order unless the ORDER BY clause is used in the query, which sorts the rows of the result set in ascending or descending order based on one or more columns.
Official source
About this result
This page is automatically generated and may contain information that is not correct, complete, up-to-date, or relevant to your search query. The same applies to every other page on this website. Please make sure to verify the information with EPFL's official sources.